Ok, thank you for the info. Changed to a temp table and it works just fine.

Pay someone else to get the work done and take credit for the effort?

Sounds like the definition of every manager / boss / owner I ever worked for.

LOL that I...

I don't recall the site where we found the details on using the blank to override the version, but it specifically mentioned passing the blank to the variable would not work consistently so...

We find this on occassion and normally correct it by resetting the Global Variable. If the package saves with the variable reading <not displayable> or something to that effect, the...

http://www.sqldts.com/default.aspx?t=6&s=103&i=218&p=1&a=7

Depends on how your packages are designed but before we moved to only ActiveX tasks, I used the branching method of this example and branched to a no-op sql...

http://www.amazon.com/exec/obidos/tg/detail/-/0672320118/103-4571327-2763050?v=glance

I think Peterson's book was the best for detailed technical discussion of coding DTS (not just drag 'n drop of tasks onto a palatte).

-- set the root and subfolders variables

' Get the from (download) directory

Set sRootFolder = oFso.GetFolder(DTSGlobalVariables("FromDirectory").Value)

' Then get the list of SubFolders beneath this root folder

Set sSubFolders = sRootFolder.SubFolders

-- the for...

Perhaps searching for something in the freeware listings would be beneficial.

I think this one uses Access as the db, but there may be others available with SS backsides.

http://downloads.vnunet.com/download/eating+drinking/wine+library/_13001.html

Some tables have the same name, but some do not. The count of dynamic tables will also vary each day.

I'm not very familiar with MS replication so must request an explanation of...

I think there is a problem with the statement:

select @FileName = @FilePath + @PackageName + '.dts'

if the path does not have the final '\'

Although the \ is added...

Perhaps this site would help.

http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/hasog02.mspx

Seems when I select a Package Name, the PackageID is auto selected.

Don't remember where I found this but it works ok.

Create a global variable of type string. Click Value and backspace until it is...

Sample script in my reply to

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=142802

+ the dynamic task as suggested by Jules. I use a branch package to determine which file type and which process to call to import it.

this is a rather quick cut 'n paste from a process I use for a similar task.

It moves files from a download area to a workarea renaming the file with...

I build connections using udl files. Change the server name in the udl based on location (dev or prod) and the packages have the correct reference.