Hi, I have an issue with my DTS and I need some help.
My global variables seem to keep the same value since the last
execution.
This is a problem for me because I need to rename a part of the file,
so the part that is not changed from the original still remains in the
new name.
Example
FILEABC_12345 gets processed through my DTS as PROCESSED_12345. If I
place a new file in the directory called FILEABC_6789 then my
processed file for that one now becomes PROCESSED_12345 since the
global variable kept that value of the original example.
How can I reset Global Variables every run? I am using
DTSGlobalVariables.Parent
Re: Multiple text files to multiple tables ... > That's for bulk insert but if you really want to usr dts you can do a similar thing setting a global variable using dtsrun then using a dynamic properties task to set it as the source file. ... These subsequent SQL tables will then be queried to ... The batch file passes Global Variables to a DTS package that first ... .txt file to the staging table which works well. ... (microsoft.public.sqlserver.dts)
Re: DTS issue....please help!! ... > Allan Mitchell MCSE,MCDBA, ... > www.SQLDTS.com - The site for all your DTS needs. ... >>> Global Variables and Stored Procedure Parameters ... >>> SET NOCOUNT ON ... (microsoft.public.sqlserver.dts)
Re: Results in email ... You can then use this article to extract them into Global Variables... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... I have a number of SQL updates that I have setup as Execute SQL Tasks. ... (microsoft.public.sqlserver.dts)
Re: DTS issue....please help!! ... Also the DTS package correctly assings a value to the ... > Global Variables and Stored Procedure Parameters ... >>I have a stored procedure that does a qc check on 2 tables. ... (microsoft.public.sqlserver.dts)
