I need to write to variables that has a scope of the entire package.
If you include the task in a container object then the variables are within the scope of the container.
I made some progress.
The Variable that contains the path & file name did not show anything when I previewed prior to including the task in the container object.
Prior to this change the variable that contained the path & file name when I selected evaluate expression did not display anything.
Now It only shows the Path which is a hard coded variable. It does not show the file prefix, datetimestamp & file prefix, so it bombs out.
I wish that I knew how to write to a package (comporable to a DTS Global Variable).
Thank you,
Kent
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/