If you have a query that 10,000 lines long, how do you get it into SSIS?

You could save it as a View in the SQL database, then simple reference the view name in the OLE DB Source adapter. What exactly are you wanting to do with this query in SSIS?Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.

Its basically a cursor, then a bunch of dynamic sql.

Create a stored proc and just call the stored proc with various parameters? Tweet me..

Save the query into a file (or perhaps it's already in one), and use an Execute SQL Task, setting the "SQLSourceType" to "File Connection", and create a connection manager for the file. Talk to me now on

I wound up saing the query to a file. Then hitting browse and loading the query in that way. It loaded it all in. I had to use ADO.net source btw.