You can try the FIELDTERMINATOR option of the BULK INSERT command.

Do you have any maintenance plans that have cleanup tasks?

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...

Waw, LutzM's reply is really brutal 😀

(but I'm thinking the same thing)

Since the maintenance plan actually creates an SSIS package and a SQL Server Agent job, you can deploy these to the other servers.

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...

When you create a job, you can specify the proxy in the jobstep.

For more information, see:

http://www.mssqltips.com/tip.asp?tip=1199

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?

Steve Jones - SSC Editor (1/3/2011)

---

I might also recommend Andy Leonard's blog: http://sqlblog.com/blogs/andy_leonard/default.aspx.

He is also doing a class later this year on SSIS. You can pick up an SSIS...

abhas (1/4/2011)

---

Hi,

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...

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...

namrata.dhanawade-1143388 (1/4/2011)

---

The error was due to something else. However, when you view a variable the fact remains that it replicates the "\" , although that does not come in the...

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 :-))

It probably has something to do with the ancient version that you are using 🙂

However, I've set the compatability level to 80 on my test database and the...

Here are some threads of people experiencing the same issue. Maybe your solution is in there:

http://www.go4answers.com/Example/vs-2008-ssis-project-data-viewers-not-29803.aspx

http://www.sqldev.org/sql-server-integration-services/data-viewer-not-popping-up-want-to-see-why-error-code-1071607683-6028.shtml