Viewing 15 posts - 9,961 through 9,975 (of 13,879 total)
prakashr.r7 (4/25/2013)
Phil Parkin (4/25/2013)
If just INSERTs, SSIS should eat that up with no need for any...
April 25, 2013 at 6:07 am
By 'Load' what do you mean? Just INSERTs, or INSERTs & UPDATEs? Or something else?
If just INSERTs, SSIS should eat that up with no need for any 'batch processing' -...
April 25, 2013 at 5:49 am
subbareddyap (4/24/2013)
I have one task, The task having stored procedure andthe task will be run daily and insert the data into Excel sheet.
Regards,
Subash.
What is your question?
April 25, 2013 at 1:12 am
Eric M Russell (4/24/2013)
Karan_W (4/23/2013)
1: Execute a storted proc and using the output create a CSV file.
2: this CSV file need to...
April 24, 2013 at 9:01 am
One thing which I can see holding this solution back as volumes increase is that the multiple EXECs are essentially single-threaded - they run sequentially.
A better-performing solution may be to...
April 24, 2013 at 4:27 am
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
Viewing 15 posts - 9,961 through 9,975 (of 13,879 total)