Container Content Edit Wierdness
Apr 11, 2007
I attempted to move some tasks into a new sequence container. It failed saying element cannot be found in a collection. Now I find that visually the tasks do not appear in the container. But in some ways they are. I can not try to move the tasks to the container, or I get the same "element can not be found". If I execute the container, the tasks outside the container run.
I thought to CUT and PASTE my tasks, but then it says "The package contains one or more event handlers for this task. Deleting the task will also delete the event handlers and the event handler context."
View 4 Replies
ADVERTISEMENT
May 31, 2007
Hi,
We tried to create a new database on an application server (Win 2003 server/SQL Server 2003) and got the following error.
error 945....
....
device activation error. The physical filename g:m
ssqldata emplog.ldf may be incorrect.
The interesting thing is that tempdb is on f:mssql as shown in the database properties and with sp_dbhelp.
Poking around in master the real wierdness comes through. sysaltfiles has 2 entries each for tempdb logs and data files. One of them is on g: and one is on f:. The lower dbid is on f: and the higher one is on g: (actually the last two rows in the table).
Several months ago our software vendor moved tempdb from g: to f: to try and speed it up a bit. Appearantly they messed it up and now have written us off till WE fix it.
The entries in sysaltfiles were the only references to g: that turned up (though we didn't look at every table and aren't even remotely sure where other references might be located).
Any pointers on getting this corrected would be greatly apprecieated. We thought about trying a reconfigure and restarting but I'm not real hopeful. We also thought about just updating the wrong entries to reflect the right locations but that smacks of kluge.
Tangential wierdness is that while trying to isolate the source of g:mssql in the error I found that in master.sysdevices the file location is e:Program FilesMicrosoft SQL ServerMSSQLdata empdb.mdf.
I believe this is from the initial install then while configuring the server it got moved to g: then to f:.
HELP!!!
Thanks in advance for any input!
Rusty
View 3 Replies
View Related
Sep 14, 2007
I'm using the Merge transformation to merge two sorted tables on four sort fields.
It all looks OK until several records share some of the same sort fields.
For example if table 1 contains
Zip Code(sort field 1) Cust Name(sf2) Cust Number(sf3) Record type(sf4)
1234 Bob 444 A
1234 Bob 555 A
and table 2 contains
Zip Code Cust Name Cust Number Record type
1234 Bob 444 B
1234 Bob 555 B
then the output order is
Zip Code Cust Name Cust Number Record type
1234 Bob 444 A
1234 Bob 555 A
1234 Bob 444 B
1234 Bob 555 B
and I would have expected
Zip Code Cust Name Cust Number Record type
1234 Bob 444 A
1234 Bob 444 B
1234 Bob 555 A
1234 Bob 555 B
Both input table are explicitly sorted just prior to the merge.
Any ideas?
View 6 Replies
View Related
Jul 25, 2007
Has anyone ever seen this issue?
If i place a loop container inside a sequence container the connectors within the loop container disappear.... is this a bug - will the loop tasks still run in the correct order?? or will they fire off willy nilly??
View 4 Replies
View Related
Apr 18, 2008
I have an execute sql task that uses the following query: (modified for this thread but normally its going to return all records in the table)
Code Snippet
SELECT
'PrimaryID' AS 'Parameter/name',
PrimaryID AS 'Parameter/value',
'LastName' AS 'Parameter/name',
LastName AS 'Parameter/value'
FROM ParkingUpload
WHERE primaryid = '1234' or primaryid = '4321'
FOR XML PATH('T2Method')
The output of this query looks like this: (I know normally this would be a bad xml file, but its needed for my purpose)
Code Snippet
<T2Method>
<Parameter>
<name>PrimaryID</name>
<value>1234</value>
<name>LastName</name>
<value>Abiola</value>
</Parameter>
</T2Method>
<T2Method>
<Parameter>
<name>PrimaryID</name>
<value>4321</value>
<name>LastName</name>
<value>Aboud</value>
</Parameter>
</T2Method>
That xml is stored in a user variable in the Execute SQL Task. I need to take that user variable and send out that xml to a webservice. The web service is expecting one record at a time(a new record is defined by the <T2Method> node.
So question is, does my approach seem fine so far? I was wondering if my next step should be to put this variable in a For Each Container and send out one record at a time to the webservice. If so, how would I go about doing that?
If anyone else has a different suggestion as how to approach this, or be able to help with the For Each portion (I am brand new to SSIS), I would really appreciate it.
View 5 Replies
View Related
Apr 26, 2006
i am trying to insert data into a table and roll back if this fails. What i have done is created an Execute SQL task with a SQL statement of BEGIN TRANS .. if the constraint = success then it goes to a Sequence Conatiner that amoungst other thing includes an Execute SQl task that does INSERT statement . outsied of the container i have 2 execute sql tasks that to a COMMIT TRANS ond a ROLLBACK Trans . when executing it i get an error the Rollback Transaction request has no corrasponding Begin tranaction. I have seen this in a SSIS created by one of the Wizards and it works fine, im oviously missing something fundemental .. any pointers ?
View 1 Replies
View Related
Apr 2, 2008
I want to create the most effective way (google) to have content displayed on a web page.
Currently, we are updating to SQL and populating to web via calling SQL statements hardcoded to page. I want to know if this is ok to do, or should we be reading from a static XML file that is updated?
I think the XML is the way to go being that i may have answered my own question, but i was curious to what the experts on asp.net had to say.
Thanks,Nick
View 9 Replies
View Related
Mar 9, 2007
an outside developer has sent us a mdf file that contains the need updates to a database.
here is where the problem comes in, how can i append the contents of the mdf file to an existing db?
there are about a dozen tables, 50 stored procs, and one new user.
View 2 Replies
View Related
Jan 22, 2008
Hello Experts,
Sorry that I open a new thread again but I didn€™t found any good tutorials about foreach loop container. I would like to read every row from one table and do something.
I red something about sql task€¦ Can someone give a little instruction, please?
Kind regards,
Alex
View 3 Replies
View Related
Jul 31, 2007
Hi,
I'm using data flow as flat file source -> derived column ->Data Conversion-> oledb destination
I have a fifty thousand record in a delimited file. while processing i got error in 45000th row. In database only 40000 records are there(why is there no all 45000 records). Is there any way to roll back all the 40000 records.
View 9 Replies
View Related
Feb 15, 2007
Hi
I using data flow task to import from flat file to database but i need to use Foreach Loop Container to import multiple files in specific folder and all will be insert in the same table
tahnks & Regards
View 1 Replies
View Related
Mar 6, 2008
hi people, i have crashed on a this problem. I have a sequence container and on this container I have set "FailPackageOnFailure=true". Now in this container there are 2 tasks. The first one is preceeding the second one. Now both this task have set "FailParentOnFailure=true". Both task are the same and their purpose is to drop table A.
1) I run the package and it fails, because there is no table to drop.
2) I create the table manualy and run package again.
3) I see, that the first task is beeing just SIMPLE OMMITED and the second task runs
In general, everytime any task in a sequence container invokes failure, next time is beeing ommited regardelss of its status. How can this be fixed ? Thanks
View 4 Replies
View Related
Feb 27, 2006
What I'm trying to do is take multiple "snapshots" of a membership for many months. I was trying to do this in a For Loop Container in which I added one to the month variable and subtracted one from an iteration variable each loop, unless the month variable = 13...then I would add one to the year variable, set the month variable to 1 and subtract one from the iteration variable. This, I was hoping, would allow me to initialize 24 to the iteration variable, 1 to the month variable and 2004 to the year variable, kick off the package, and get 2 years worth of "snapshots" in seperate files (one for each month). Here is the AssignExpression I thought would work:
@Member_Month == 13 ? @Member_Month = 1 && @Member_Year= @Member_Year + 1 && @Member_Iteration = @Member_Iteration - 1 : @Member_Month = @Member_Month + 1 && @Member_Iteration = @Member_Iteration - 1
The package states that the single "=" should be double, but I don't think that that is what I want to do (I tried doing this just to check, and it didn't like this either). I think that it is having problems with doing multiple things on both sides of the ":". What am I doing wrong?
Thanks,
Brian Layden
View 1 Replies
View Related
Oct 19, 2007
Afternoon Folk ...
Here is the question.
I have a RAID 10 container consisting of 4 146GB, SAS, 3.5-inch 15K RPM Hard Drives.
We have the OS on its own RAID so we are strictly dealing with setting up SQL Server 2005 on the RAID 10.
SO ... is it better to create seperate volumes for the Data, TLog and TempDB file placements (i,e, C:, F: and G or is it alright to create just plain-jane folders for the file placements?
Does it make a difference?
Is there a better way to carve this RAID 10 up?
Thanks ALL!
View 7 Replies
View Related
Jul 24, 2006
Has anyone investigated extending any of the SSIS Container classes?
I have been looking into it because we'd like to add a set of standard logging calls on events, standard startup procedures, etc. on any package that we execute.
I've been looking into the Sequence Container, For-Each, etc. They are all sealed classes. I'm not sure why MS has sealed them.
We're currently thinking of implementing our own version of the Sequence Container -- we'd really like to be able to extend the functionality of a standard container class, but we don't want to have to implement the actual container class itself.
Any insight appreciated.
View 5 Replies
View Related
Aug 22, 2006
Is there a way to set a variable as a substring of the enumerator in a Foreach File Enumerator type? The Variable Mappings tab in the Foreach Loop Editor does not allow you to enter an expression.
Fred
View 13 Replies
View Related
Oct 24, 2006
hi guys,
I was wondering about a silly thing but, anyway, which is the maximum number of grouping for a container? I mean, when you group from, i.e, a sql task and then over that group do again another one and so on...
Thanks in advance for your time,
View 3 Replies
View Related
May 18, 2007
We have a config table which has columns like pollingfolder, cop to folder etc.
Data looks like this
Config id polling folder
1 d:dataloadacn
2 d:dataloadship
under ACN and Ship folders we can have more than 1 source files which had to be loaded into target
the load process has to be repeated for each file in all the folders like ACN and ship
I have used for each loop container to poll the folder.
Can we set the directory to be polled at runtime taking from config table.
For doing this I have used the property Directory in expression editor of for each loop. But it is not working.
If I hard code the variable value in variables section , then its working.
How to change the directory to be polled value at runtime?
View 1 Replies
View Related
Apr 25, 2007
I'm trying to set up a For Loop Container that steps through the loop based on date logic.
Here's an example of what I'd like to do:
InitExpression | @SomeDate = 1/1/2007
EvalExpression | @SomeDate < GETDATE()
AssignExpression | @SomeDate = DATEADD(DAY, 1, @SomeDate)
The above syntax does not work, and I can't find an example that uses date logic with the For Loop Container.
Can anyone help me with this, or point me to an example that uses the For Loop Container with dats?
Thanks in advance for the help!
View 9 Replies
View Related
Mar 12, 2008
Hi,
I am using For each loop container in my SSIS package which will loop through more than one input file in the input folder.
All the input files in the input folder are picked by one by one. All the input files in the input folder are executed with the same ExecutionInstanceGUID.
Now, my requirement is to get a new ExecutionInstanceGUID during the execution of each input file in the For each loop container. My package only contains the For each loop container with some logic inside that.
Please let me know if any one can help me for the same.
Regards,
Sriram.
View 6 Replies
View Related
Apr 20, 2007
Hi Guys
I am trying to do the following and am quite new to SSIS.
I have to select a dataset from a database on server A, check if it exists on server B and perform an Update or Insert dependant on the existence.
I have created a SQL task to do the Select from server A with the results set passed to a variable of Vendors. I have added a ForEach Loop container with an enumerator of Foreach ADO Enumerator and the source variable is set to Vendors.
I have created 2 variables in the Foreach Loop called Code and Supplier - both as strings - as there are 2 fields from the initial Select that need to be passed to the final Update/ Insert.
I have then created another SQL task insert the Foreach which will perform the Update/Insert.
obviously when I run it at the moment it performs the Update/ Insert but just adds the rows with both Code and Supplier as NULL.
having looked at a couple of examples in books I have i know i need to add something in the Expressions of the Update/Insert SQL task but it is here i get a bit lost.
Which of the properties from the drop down do i need to use to map the variables against?
Any help would be massively appreciated asI am tearing my hair out!
Thanks
Scott
View 5 Replies
View Related
Aug 27, 2006
Hi,
A very strange thing happened to me. I have a package that includes two For each loop containers. Each container has script tasks, sequence containers, etc. Both are Foreach ADO Enumerator basis. It works without any problems until I changed the position of one of them in the Control flow and added some code in the script task. After these changes I executed the package and both of For each loop containers did not execute the tasks inside of them, any task. However the execution color on the containers was green (success). How can it be?
Your help is much welcome. Thanks in Advance.
JoĂŁo Cruz
View 2 Replies
View Related
Mar 30, 2007
Hi
Can anyone point me to an example of using a ForEach Loop Container to step through the rows in a recordset. I cannot seem to see how this is done from the help files.
Thanks
View 6 Replies
View Related
Oct 15, 2006
Hello all,
I am trying to build a package running a container that includes several tasks: 2 Execute SQL tasks and a data flow task. I would like to execute this container in a single transaction, which means that if any of the tasks fail, no changes are been made by the container execution.
To achieve this, I have followed the instructions of how to configure the DTC on the server and locally, and set the container's TransactionOption Property to "Required".
The problem I encounters is that when using a dataflow task in the container, the running process runs OK until it reaches the dataflow task, then it just gets stuck (marking the task in yellow). When removing the dataflow task, left with only Execute SQL tasks everything works fine.
Any idea?
Thanks,
Liran
View 8 Replies
View Related
Aug 13, 2007
WHAT IS THE USE OF THE FOR LOOP CONTINER
PLEASE GIVE ME THE EXAMPLE
REGARDS
KOTI
View 5 Replies
View Related
Feb 26, 2007
Hi,
I am having problem when setting for-each container's EvalExpression as a variable comparison.
I have set this in expression editor
@[User::Syn] == 1
Editor says that it couldnt convert from System.Bool to System.String.
If I put it in quote, then for-each container says that it needs Bool, not String.
Please help me with this,
Thanks
View 7 Replies
View Related
Aug 22, 2006
Hi everyone,
I'm just using TEXTBOX control to save data into my DB. My question is, if I have multiple lines of sentences, it does not store as what it looks like. For example;
Hello, Mike
It stores into the database as "Hello, Mike" and if I read from the database, it does not have seperate lines and shows it like this;
Hello, Mike
How can I store the contents into database and make the contents as original? (Sorry for the poor English, but I hope you understand it.)
View 2 Replies
View Related
Jun 21, 2007
Hi All,I have a job coming up which involves me creating a vacancy system for our website.I (think) I'll only need one table:ID (PK)JobTitleJobLocationSalaryHoursJobDescriptionValidFrom (Date/Time)ValidTo (Date/Time)I'll display this data using a C#.Net repeater but I was wondering how I can automatically strip the page of the jobs that have gone past their expiry date? Is is straightforward to achieve?Thanks in advance,Brett
View 2 Replies
View Related
Jan 14, 2008
HiI have developed a sql procedure for updating some xml content using SQL 2005 xQuery features.For example:Declare @xmlContent = '<books><book name="asp"/>< book name = "sql"/></books>'--Now I want to add attribute "book_id" to the xml content.SET @xmlContent.modify('insert attribute book_id{"1" } into (/books/book[@name="asp"])[1] ')SET @xmlContent.modify('insert attribute book_id{"2" } into (/books/book[@name="sql"])[1] ')SELECT @xmlContent--OUTPUT will be<books><book name="asp" book_id="1"/><book name="sql" book_id="2"/></books>QUESTIONQ1. Do we have any extension or plugin such that this SQl 2005 xquery feature can be incorporated in SQL 2000?Q2. If the answer for Q1. is no (as I expect), then do we have any TSQL feature in SQL 2000 for modifying xml content?I found all examples in SQl 2000 related with "openxml" function which performs the select kind of operations only. Like selecting data in XML format OR converting xml data in to tabular format. But I couldn't find any xml modification TSQL in SQl 2000 which can add element/attributes or change values.one workaround could be to consider xml content as string and use string functions to modify the content.But is there any more sensible approach available in SQL 2000?
View 1 Replies
View Related
Dec 29, 2003
Okay, moving to developing a small site that will be storing articles - that is a site largely consisting of html marked up articles with images. We already have an SQL Server so it is becoming the back-end.
So, since I'm not an SQL Server expert, some general advice on this would be appreciated? The articles, as I say in HTML (largely just markup for titles, and general text) would be stored in the DB? As Text datatypes?
How about the images...on disk or in SQL?
View 3 Replies
View Related
Nov 12, 2001
hi everybody,
The problem is, I have a table with one column of varchar(8000) datatype. It has got 1000's of records. Through Query Analyzer, I am not able to view my records after 257 columns in my table, even I increased my textsize by using 'set textsize' command.
Any other setting is available to correct this. Any help is appreciated.
thanks,
Vasu
View 2 Replies
View Related
Sep 10, 2001
I have a particular production database that on a few recent occasions has suddenly had one of it's tables empty of content. Now there are no jobs or triggers in place neither is any stored procedures that could perform a delete or alter table operation in place. The permissions have been set not to allow this either. The datatype is text only. What is intriguing is the QA server has an exact mirror and this dosen't happen. Has anyone come across this sort of phenomenon?
View 2 Replies
View Related
Feb 24, 2000
Hello,
I have a field in a table called 'CourseId' - the course Id should always contain a backslash somewhere in the list of numbers eg :
12342322
11231131
Unfortunately, some of the course Ids have a forward slash instead of a backslash eg :
462322/1
23/232323
How can I update the field to replace the / with a
Any help is very much appreciated.
Thanks in advance,
Anthony
View 1 Replies
View Related