Viewing 15 posts - 12,646 through 12,660 (of 13,849 total)
You could try a FOREACH container - put your File System Task in it and it should move all of the matching files one by one - after just a...
July 11, 2009 at 2:13 am
Please post the full error message, not just the codes.
July 10, 2009 at 8:02 am
When your source data is already in a single database there is no need for a merge join ... just write a query to bring out the data that you...
July 10, 2009 at 6:28 am
You need to create the new variable outside of the script task first - same as creating your other variable. Your script task just sets its value.
For the script task,...
July 7, 2009 at 8:32 pm
There is a thread here - and specifically a post by NaffMonk - that seems relevant to what you are trying to do.
http://www.sqlservercentral.com/Forums/Topic531295-148-2.aspx
July 7, 2009 at 8:28 am
Are the field names / types always the same, or do they need to be dynamic too?
July 7, 2009 at 8:25 am
There is no function which will look at a column of data and return you an appropriate datatype. This is something which Excel tries to do when it opens a...
July 6, 2009 at 10:00 pm
I have not seen this error before.
Please post the code from your Script task.
How is Oracle involved in your package?
July 6, 2009 at 9:56 pm
Never got to the bottom of it. Somehow, by some means, the problem stopped happening for me. I have no idea why. Seeing your post reminded me of just how...
July 6, 2009 at 9:52 pm
You probably need to use a Script task to assign the text and access the contents of the variable - otherwise you'll just get the literal text in there.
July 6, 2009 at 7:04 am
OK, not quite correct for an OLEDB source.
First you need to assign the whole SQL string to a variable, then you need to change the Data Access Mode on your...
July 6, 2009 at 6:36 am
Use an Expression to set the SQL ... That will decode your variable for you.
July 6, 2009 at 6:21 am
Ah, yes, I see it now. That would require detailed knowledge of importing from XML, which I do not have, sorry:-) But, in SSIS, there's always a way ... it's...
July 5, 2009 at 7:18 pm
Your example did not appear, but you should check out the Multicast transformation to see whether it gives you what you need ... one source to multiple destinations.
July 5, 2009 at 6:50 pm
Perhaps this thread is relevant to what you are trying to achieve?
July 3, 2009 at 2:10 am
Viewing 15 posts - 12,646 through 12,660 (of 13,849 total)