Viewing 15 posts - 10,636 through 10,650 (of 11,678 total)
I still don't know what you are trying to do.
Are you moving or copying data? Or are you deleting it?
From SQL Server to another SQL Server?
Is all the data in...
January 4, 2011 at 7:42 am
I think it is best that you start up a new thread for this, as it has little to do with the original question.
January 4, 2011 at 7:37 am
pt9s (1/3/2011)
How would I use bulk insert with a text qualifier?"Conan", "O'Brien", "123 Cedar Circle, 1", "Los Angeles", "CA", 90025
You can try the FIELDTERMINATOR option of the BULK INSERT command.
January 4, 2011 at 7:34 am
Do you have any maintenance plans that have cleanup tasks?
January 4, 2011 at 7:26 am
Can you give some more information?
Or you copying or moving data?
Where does the data come from? A relational database, flat files, mainframe...
Do you append the data to something? Do you...
January 4, 2011 at 7:25 am
GilaMonster (1/4/2011)
<sigh> Talking plagiarism. He really should know better...http://www.sqlservercentral.com/Forums/Topic1042151-2799-1.aspx
Waw, LutzM's reply is really brutal 😀
(but I'm thinking the same thing)
January 4, 2011 at 7:22 am
Since the maintenance plan actually creates an SSIS package and a SQL Server Agent job, you can deploy these to the other servers.
January 4, 2011 at 7:19 am
That's weird. You can check the advanced editor of the source component to see which datatypes SSIS uses for the other columns. If they are unicode, change them back to...
January 4, 2011 at 6:57 am
When you create a job, you can specify the proxy in the jobstep.
For more information, see:
January 4, 2011 at 4:57 am
How come you are getting errors on columns X, when you are supposed to load only one column?
Did you select all columns at the source?
January 4, 2011 at 4:53 am
Steve Jones - SSC Editor (1/3/2011)
He is also doing a class later this year on SSIS. You can pick up an SSIS...
January 4, 2011 at 4:04 am
abhas (1/4/2011)
I want to know which executable is essential to extract compressed files which are compressed by built in windows xp functionality?
i.e. i want to know which exe is...
January 4, 2011 at 4:01 am
What are the exact errors that you get?
Maybe you can give the schema definitions of the source table and the destination table, and if possible, some sample data. Also explain...
January 4, 2011 at 3:59 am
namrata.dhanawade-1143388 (1/4/2011)
January 4, 2011 at 3:55 am
Frustrating indeed.
Is your installation updated with the latest service packs?
Someone mentioned also problems when using more then one data viewer.
(I'm just guessing here :-))
January 4, 2011 at 3:10 am
Viewing 15 posts - 10,636 through 10,650 (of 11,678 total)