Yes, I can copy a file without the * wildcard. Is there another syntax for wildcards? It's unknown how long the name of the file would be, for example ?????.csv...

How 'bout this as an option? I copied and modified a script found that might allow me to stop a 'hung' job long after it should have completed.

I could add...

Found and solved my problem. I hadn't recognized the significance of the 'index' column in the variable mapping. Once I had my second 'name' variable in position 2, and set...

TADA! Bravo! Bingo! Ok. My SSIS pkg works top to bottom. After banging away on the various properties and variables, I was able to make it all work. I am...

PD et.al.,

Your steps pointed me in the right direction, but I took the easy, convenient path to get up and running. I was able to create the project using...

Thanks Jeff. The link really helped. I settled on the SQL2005 'stuff' function. Once I kicked it around enough times to get the joins right, it was perfect.

STUFF((SELECT ', '+...

Thanks All. After having no success creating a 'DELETE FROM. . .', I set up the File task. It was much easier, and very quick, using the copy file [template,...

Thanks all for the imput. I loved the thread and shared the complexity with fellow staff.

For my purposes, The DATEDIFF works well for me because I am rarely calling...

Antonio and Adam --Thanks for your help. I worked out a solution mixing your ideas. Antonio's script still displayed todays data with the >=.

So, with a little modification:

DECLARE ...

Adam, et.al.,

Sorry for the late get back. Finally, on the weekend, we rebooted the server, which took care of the anomaly. "Wipe on, Wipe off". So many issues are managed...

Thanks Greg, and Steve! That works!

The developer was using SSMS and could not view the legacy dts pkgs. If I gave him sysadmin permissions, he could access them. I would prefer that he only be...