Maybe SSIS is using regional settings to determine the date format when writing to the destination flat file.

I would use the DT_STR datatype in SSIS (string datatype), convert the date...

Regarding the extra rows:

if you type something in a cell in Excel and delete it, Excel will "remember" that there used to be data and you'll get null rows in...

http://en.wikipedia.org/wiki/Null-terminated_string

When you run this query, you get a really good description in the error of what is wrong...

Nice back to basics question, thanks.

You still have IMEX=1 added in your connectionstring?

Did you modify the TypeGuessRows registry setting?

Is the type of the column in Excel set to Text, instead of General?

So that the package doesn't crash when you use any kind of dynamic configuration?

Matt Miller (#4) (3/9/2012)

---

As an FYI - you can also do this from a client machine with visual studio. From within an Integration Services project you can "Add Existing...

This article explains how to read an object variable in a script task and how to put it in a dataset:

SSIS Design Pattern - Read a DataSet From Variable In...

mister boom (3/9/2012)

---

Hey Koen, thanks for all your help.

When I clicked MSDB, I got a message:"Failed to retrieve data for this request....The SQL server specified in SSIS service...."

I managed...

Use...

L' Eomot Inversé (3/9/2012)

---

In the UK it is currently not permitted to make copies of copyright material onto new media, so there is no copyright levy on empty storage. ...

Look in the MSDB node instead of the File System one.

If you really want a web interface you can try Cognos Analysis Studio.

It can...