run the SQL script in a Data FlowTask and output the results to a variable of type: Object, coped at package level.

Set up a For Each Task that enumerates the...

I'm with Lowell on this one. Something has gotten hold of the file you are trying to write to. You could try writing to a unique filename (add...

And once again Excel and SSIS don't play nicely together - please sort this out Microsoft. After RDBMS, Excel is the most common source of data for most organisations

It sounds like you need Redgate's SQL Data Generator.

Another Gotcha with Progress.

If one of the column names is a reserved word then you need to surround it in "Double Quotes" rather than [square brackets] as you would in...

Hi Bill,

Further playing around and the SUBSTR() function seems to work for me. Now just to deal with "?" in null date fields. Which eejit decided that nulls...

They do, and its OK but like the RedGate packages, its a bit expensive on its own and I have not been able to get buy-in where I am to...

@jeff

+1 for Redgate. They are really helpful and the products are really useful. i especially like the source code control plug in for mgm studio and...

I'm with Jeff!

If you put everything in one corner, you know where everything is!

If the new and changed records can be easily identified, I would side on the staging tables having the same structure as the source data. If not, and you...

you need to use the expressions (left hand pane in the editor window) and create a formula that appends the date before the file extension. I don't have SSIS...

Also, Tell your C# developer that the underlying DB is none of his damn business - He should be using sprocs or LINQ to get data in and out of...

Writing data into an OLTP and reading data from an OLAP are completely different beasts, especially in high-transaction scenarios. To keep the speed of the inserts up, you need...

Not wanting to hijack the thread because we are getting OT now.

By utilising schema separation and controlling access through users rights you can force segregation of data which for some...

The only thing worse than data modelling and Agile is data modelling without Agile.

Strangely I have been researching this all of today and I'm going to be a bit Off...