I was finally able to run a sssis package with variables passing to "Script Task" which in turns used Crystal Resources to genereate a pdf file. I had another...

Thanks for all the replies...yes, I have thought about third party software to build command line; and I have not used Reporting Services at all yet. I think using...

Yes, this is not my first time here and yes I will do a better effort to provide both data and script.

I just really did not know how to begin...

Thanks for all the feedback!!

The Division values are not in sequence, so my example was not very good.

But it is great learning about the Tally Table for duplicating sequencing and...

What do you mean by "Using a Tally table/CTE probably"?

I was thinking of inserting one group of Division records into a new temp table, then do an update to change...

Thanks, doing the manual edit on the xxx.dtproj file worked just fine for me...very nice...thanks again.

Using Sql Server Business Intelligence Development Studio, Integration Services Project. Packages are created/stored using the File Server.

I will probably have about 50 to 60 packages and it will make it a lot easier to find the package if it is alphabetical.

Also, this will group my packages....

Need more help...now the package runs ok the first time as the target table is empty and the records are not found and performs all inserts. The second time,...

The convert on the select from source worked. Thanks again for the help.

ok, I used the Derived Column transformation; selected Source Customer_Number, created new derived name New_Customer_Number. Changed Data Type to DT_STR, len 10. Still does not work on lookup...

The domain/admin has all rights to the network backup folders

The is true because I already have a sql2005 box that backs up to it; and this box has the sql...

I want to thank everyone for the quick replies and suggestions.

I did have a new domain network account 'sqlBackup' created awhile back; but when I attached that new account to...

sql services are setup for local account currently; how do I verify the local account has sa rights? Does the local account represent who I log into the server;...

Yes, I would like more detail using the variable conditioning as previously mentioned. Thanks again, Rich