I am still a bit mistified, do you mean they buy different data every day?

Basically, you would have to set up a connection manager for every different layout

Ahhhh makes sense

Thanks Michael

That is why I am such a huge fan of SSIS configurations.

It assigns all the connections when the package loads, and hence I dont need to worry about saving any...

If you have SSIS Configurations enabled it is simple, just change it there to run against the target server and TADA

~PD

In normal circumstances, I would suggest that you use a execute SQL task to simply drop and create prior to performing the dataflow.

However, have I got you right, that your...

Hey,

Are you running this from BIDS or from SQL server agent as a SSIS Package?

~PD

Why can you not use the standard OLEDB connection?

I have Adaptive Server ODBC driver installed for our Sybase IQ warehouse, and it appears under my list of Providers as Sybase...

Use a file system task. One of the features is that it can delete files

~PD

hey Nat,

Welcome to the joys of SSIS...

I had the same error thrown in my agent yesterday, and I was adament that there was something wrong with the way in which...

I would wager that whatever is running the SSIS package (normally the agent), doesnt have sufficient rights to the SQL connection

For sure its possible....

First lets conceptualise a little, you basically need something that will return 2 dates to you - current month and previous month.

Everything will be based on these...

Are you using config files, and how are you connecting to SQL (windows or SQL authentication?)

Well you are transferring data 100 + times right

Enable package logging. This will allow you to see where in your task the data is "disappearing" to

~PD

:blush:

oiiiii

I was so sure I had dont save sensitive selected. You dont want to know how much time I wasted looking at a problem where the problem was with the...