I know, I know... Dynamic Properties Task does not exist in SQL 7. I googled it and found: http://www.microsoft.com/technet/community/chats/trans/sql/sql0227.mspx
(MarkChaffin: I'm using SQL 7.0 - is the dynamic properties available there? Don't recall running into it
Host Guest_MarkChaffin
No they weren't there in SQL 7, but you could get around it by building a simple Ax script to update globals by reading an INI file...Sort of your own Dynamic Properties task...)
See, what happened was that my data cleansing project required me to create a process to import a ton of excel spreadsheet into a SQL Server table. I found this famous ariticle: http://www.databasejournal.com/features/mssql/article.php/3073161
I spent some time learning Perl and wrote a script to loop through all the filenames within a directory, changing the .ini file. Then, I created the DTS package on my local SQL 2K dev box. Everything works fine!
Finally, time to move it to production testing environment. BAM!! SQL Server 7 doesn't have Dynamic Properties Task!!! God, I'm so screwed!!! Please.... the MS host said we can write a "simple Ax script to update globals"... does anyone have something like that written? Or can write one up real quick? I have no idea where to begin, having never used ActiveX scripts.)
Thanks!!