Viewing 15 posts - 11,371 through 11,385 (of 13,871 total)
prashavhad (5/31/2011)
Use Bcp Utility for this,create your format file without mentioning -t in format file
Thanks & Regards,
Prashant Avhad
How does this solution address the ftp requirement?
May 31, 2011 at 12:28 am
if you don't include a question in your post, how can you expect an answer?
May 28, 2011 at 4:42 am
Sounds like a simple SSIS package just waiting to be written ...
May 27, 2011 at 12:22 pm
I would advise you to consider a modification to your update methodology. With large datasets, this RBAR method performs badly.
A faster alternative is to send the records to be updated...
May 27, 2011 at 10:45 am
Great. My pleasure.
May 27, 2011 at 5:38 am
Ah yes, I see.
You could try this sort of thing:
SET @finalQuery = 'SELECT acc.[ACCOUNT], acc.[NOIND], tr.[S''mentdate]'
May 27, 2011 at 4:46 am
I'm not 100% sure what that code is doing, but I'm guessing that somehow the derived SELECT query is being used to create a table on SQL Server?
If so, just...
May 27, 2011 at 4:17 am
What is your question?
May 27, 2011 at 3:35 am
tulenkog (5/26/2011)
And when the data conversion component doesn't work, what else can you try?--
Sorry dude: it does work, I can assure you.
May 27, 2011 at 1:54 am
SKYBVI (5/26/2011)
I click on .dtsx file and copybut when i open another package
i cant paste tht .dtsx file here.
Regards,
Sushant
Expanding on Koen's reply a little, SSIS packages are discrete dtsx files....
May 27, 2011 at 1:51 am
Sean Lange (5/26/2011)
Phil Parkin (5/26/2011)
I use a binary search to do this...
Phil the pedant steps in 🙂
What you have described is a 'bisection method' - a binary search acts on...
May 27, 2011 at 1:45 am
asm1212 (5/26/2011)
I have done that however, he doesnt want to copy over the sp's and other objects, he just wants the data...also our backups are only on tape...
It would be...
May 26, 2011 at 1:29 pm
"This kind of data" does not really cut it as far as a spec is concerned. Also, this is not strictly duplicate data.
So far, my spec would be along the...
May 26, 2011 at 12:57 pm
Have you considered a straightforward backup/restore?
May 26, 2011 at 12:48 pm
Open the package in BIDS, then File/Save a Copy ...
Or just copy/paste the underlying .DTSX file.
Check afterwards that the package IDs for the two packages are not the same (if...
May 26, 2011 at 10:05 am
Viewing 15 posts - 11,371 through 11,385 (of 13,871 total)