if you want to go down the path of looping through a folder and checking file sizes, there are two steps to add to your package. (I like this idea,...

one thing i noticed is that this package has not completed yet so you do not know how many records are being returned out of the union all transformation yet....

you can create a package on your SQL 2005 server to run the steps you are asking as a SSIS package can have a SQL 2000 database be the source...

There is an option to setup a SQL command from a variable. However, if you are going to parameterize the Table Name, will the structure also be changing on your...

Joe

If you are only returning a single row, what you need to do is set the Execute SQL Task ResultSet property to be Single row.

Then, in the Result Set page,...

i appear to be incorrect in that the conditional split is still creating the file, sorry about that. i was also thinking off the top of my head.

what if you...

mark, i think the issue here is that the decision to write to a flat file is occurring in the data flow, where you cannot use a precedence constraint within...

one approach, there is a row count data flow task that will add the row count value to a variable for your dataset and you can then perform another conditional...

Joe

On my corporate Blog, I have a blog detailing how to loop through a collection of files and load them into sql server database without knowing the names of the...

the only answer i have come across is to create a new project and use the Import Analysis 9.0 database as the template type or you could open an Analysis...

well, without much insight onto the nature of the csv file to load, what you are asking for can be really simple.

setup a flat file connection to point to the...

you answered how to do it.

the only downside i can think of is if a different zip file was placed in the source ftp site in addition to the...

funny this came up, i just wrote up a quick blog on my corporate blog site on the steps to perform the load. here is the link:

http://rdabiblog.com/

the topic...

ok, this is what i did to get your scenario to work. i originally populated the sql string variable with the stored procedure call so i can get the metadata...

hmm, for curiosity, what is the value of your string variable in design time? is it empty or does it hold the value of your stored procedure that you want...