Consider using a drop table/create table command, which will effectively delete the worksheet and replace this with a new one.

~PD

Hey Martin,

Quite a long posting, didnt read through most of it, but thought you would like some feedback on configurations ....

I use SQL configurations quite successfully, and port across environments...

Did you specify SMO connections?

Thanks man, will do so with a dash of speed

Actually very easy, create a derived column with an expression inside

Something like Sourcefieldname == "00/00/00" ? NULL : Sourcefieldname

You will have to read up on the correct Null function to...

Hey,

Depends on your Sybase version that you are running.

From previous threads, I understand with later versions you can use OLE DB, where your Sybase driver should appear under the native...

And assuming that you have referential integrity switched on at the RDBMS level, SSIS will fail unless you keep the parent/child relationships intact

~PD

Michael,

My client doesnt use source control, simply because there is but one SSIS guy around here (me). I am hoping to change the approach moving forward (took me forever to...

hey,

Really nothing to it....

On your solution explorer, make sure that you select the package you want to change.

In your properties window, you will find all kinds of properties relating to...

Uhmmmm

I am not understanding nicely. Do you mean there is no dimension currently, or do you mean that there is a dimension, but simply no SSIS lookup table?

You can use...

Only requirement if you are transferring objects is that you have SP2 installed (which is absolutely key in any event to successfully running SSIS).

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=127100

With the transfer objects task,...

Really nice article, with a lot of how-to's.

I cannot stop raving about the added flexibility, such as what is described in the article, which will make SSIS king of all...

Agreed...

If you simply want to return the titles, its a simple case of joining via ID and returning the fields from the tables, regardless of the many to many relationship

~PD

This doesnt make sense

Are you saying that table 1 has a pk, with a FK to table 2 (PK), and table 2 has a pk, with a FK to table...

char(13)