Viewing 15 posts - 9,961 through 9,975 (of 13,874 total)
Are your source and target tables on different servers?
The MERGE statement won't work in this scenario - you need both the tables to be on the same SQL instance, I...
April 24, 2013 at 4:10 am
Are you saying that you know that there are SSIS packages in MSDB, but that you cannot see them?
What did you do to receive that error message? Which tool were...
April 24, 2013 at 1:54 am
P.S.... Did you know that Durians are outlawed on pubic transportation in some of the countries they are grown/imported?
Yep - with good reason too. I can't get near enough to...
April 24, 2013 at 1:50 am
I knew that you'd have your reasons - sounds robust and safe to me.
April 23, 2013 at 12:21 pm
CptCrusty1 (4/23/2013)
Flow is as follows:
Text File --> Raw Table --> Staging Table --> Production Staging Table (Different VM) --> Production Table.
A lot, if not all of the Transformations happen...
April 23, 2013 at 11:04 am
If no data is pushed along the output, the output will do no work. That is not to say that it won't be validated when the package fires, so there...
April 23, 2013 at 10:55 am
girl_bj0619 (4/23/2013)
i meant where to apply it?here..?
merge ...
using....
Can you take a bit more time to write out what you are trying to do please, because I do not understand your...
April 23, 2013 at 10:48 am
CptCrusty1 (4/23/2013)
April 23, 2013 at 9:09 am
Have you checked out the Conditional Split transformation? It allows you to redirect data based on tests such as these, so you could split your input into multiple streams, with...
April 23, 2013 at 9:04 am
girl_bj0619 (4/23/2013)
how does the query works?
Execute At [linked_server]
causes the statement to be executed on the linked server (not on the server running the EXECUTE statement). Is that what you mean?
--Edit:...
April 23, 2013 at 8:57 am
Your message is a little confusing: are you importing or (I think) exporting?
What do you mean when you say that your file layout "becomes a mess"? Can you provide some...
April 23, 2013 at 1:13 am
Taking SSIS out of the equation for a moment, do the queries run quickly in SSMS?
You need to do some detective work to understand exactly where the bottleneck is.
April 23, 2013 at 1:08 am
If E: is not a local drive on the server, I would try using a UNC file path instead.
April 22, 2013 at 10:51 am
Great - thanks for that!
April 22, 2013 at 1:17 am
Have you configured the output as 'Append' or 'Overwrite'?
If only the final file is appearing in there, I would suspect 'Overwrite'.
April 22, 2013 at 1:10 am
Viewing 15 posts - 9,961 through 9,975 (of 13,874 total)