Why dont you save the SSIS package when doing the wizard.

Then you can compare what the wizard is doing versus what is occurring in your dataflow task.

~PD

Hey,

The execute SQL task is actually creating a worksheet called "Query".

If this worksheet exists, it will simply append to the data already there.

Why not simply have a drop table 'Query'...

Venki,

If your info is not sensitive, post your code and .dtsx file, and we will see what we can do.

ESPECIALLY, since you have SSIS, cursors should be forbidden

~PD

uhm,

I am misunderstanding you here.

For my very small brain (and I mean REALLY small brain), lemme try to recap.

You have stored procedure A, and you want to take the results...

Any ideas as to when MS will release a better xls driver, as the current one certainly has a couple of pitfalls in it?

Uhmmmmm, not sure, but I dont think its necessary to install Office to work with Excel source and destinations.

Be a bit more descriptive of what the error is

This is very hardcoded, I didnt add a lot of dynamics.

For example, I assumed that the directoryname would sorta look the same each time.

I add a variable date and time...

Cool. You go do waretst, with its more than 100 columns, and I do an example of tblUserInfo with 10 columns.

Little bit of advice, unicode is going to bite you...

I had a look at your mdb databases, and there are some seriously wide tables in here.

I will make a dtsx out of a single table, I just aint gonna...

Uhhhhmmmmmm, with all due respect, I can guide you, but you have to sweat this one out yourself. Else I will always be stuck with the For Each kinda knowledge,...

Yes, that reply was almost a month ago...

Whatever is written in there still holds true, just tag it to traverse subfolders in your case.

Sigh, okey, lets start from the begin......

Brandie,

Thanks for setting the validation part straight. One day when I am grown up, I will start playing with some serious SSIS performance tuning...

Kirk Hassleden wrote a reaaaally good SSIS...

Agreed, normally this error occurs when SSIS doesnt like something that you scripted using the .NET IDE

are you sure your wildcard is in the right place?

I use traverse subfolders without any hassles

~PD

Venki,

In SSIS you get for each loops which do all kinds of things, and really assist with managing the loads into your environment.

BUT (and this is the big but), none...