December 28, 2004 at 1:44 pm
Is there a way to organize DTS packages into folders? I have about 600 packages that I'd like to organize into specific groups or departments, instead of scrolling through all 300 to find the one I need. Does anyone have a method to do this?
Why so many you ask? I create one package to work on one company in the organization, export the package to vb, and then replicate it 82 times for each of our other companies, to pull and consolidate all of the dBaseIV datafiles into one datafile for reporting. So, I have every package duplicated 82 times, the only difference being the company id number (which is how the dBaseIV files are named). Any idea how to organize this mess?
Elainna
December 28, 2004 at 3:25 pm
Unless you want to store them in the filesystem and not on SQL Server, you can't as far as I know.
I've had the same problem and used the package description to organize per company, which allowed me do do a sorting on that field in EM and finding the relevant packages faster.
Since it sounds like you're doing exactly the same for each company, one thing that could reduce the number of packages would be to store the companies somewhere and then use a looping approach as in this article http://www.sqldts.com/Default.aspx?298
Thomas
January 5, 2005 at 6:48 am
Thank you for your reply!
I did try to do the loop, which I can do with my data. However, part of the parameter that I need to pass is part of the table name. We pull dBaseIV files into SqlServer, so it's not a great design, but each table contains the company number to distinguish what data we are looking at.
I was able to build a sql statement in an ActiveX process, but I don't know how to use the compiled Sql string to to a DTS from SQL Server to an Excel file.
Thanks for the newbie help though, this site is very helpful!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply