You could use an ActiveX script setup in either 1 of two ways:

Both ways involve the ActiveX script evaluating the Global Variable of the table that you wish to pass...

Can you not use the DTS Dynamic Properties task to assign the gv value from the INI file?

How's Database Administrator Developer and Intergration.

Then whoever get's the job can simply ask: Who's the DADI?

There's a forum on here where someone had the same problem. It might help.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=131&messageid=210372

eWeek have now confused me slightly.

On the one hand you have the top 10 technologies that flopped, including Voice Recognition. Citing that in...

There is no simple way that I know of to do this.

The data stored in the packagedata column is encrypted and therefore can...

You might want to look in to the xp_smtp_sendmail at http://www.sqldev.net/xp/xpsmtp.htm as an alternative to the SQL Server mail.

As for the change in name, you could use an ActiveX script...

When a DTS package is executed through Enterprise Manager it uses the local resources on the machine when scheduled as a job the package uses the resources on the SQL...

Hi Mark,

Welcome to XM-HELL... Just kidding!

Maybe.

SQL Server is definitely capable of handling XML files. Start by having a look at XML-related pages (such...

You could try using the FileSystemObject to open a text file for Unicode writing using the Tristate switch in the OpenTextFile method.

Function Main

 Dim fso

 Dim fol

 Dim f, sFilename

 Dim ts

 Const ForReading =...

You might be able to use an ActiveX script in your data pump task to only transfer the row if the source date column meets a specified criteria. The script...

If you just wanted to default any row to NULL or A.N.other date you could use an ActiveX script to copy column in your datapump task. The below will default...

The package won't fail on the first step when the step is run on it's own as an Execute Step because whatever connection is broken does not need to be...

Loner,

If nothing else, a therapist will help you to understand the sources of your stresses and concerns about both home and work. Sometimes it takes a stranger's ear to...

David,

Hi, I've just run the query through Query Analyzer and using Studio Express and not found a problem. What are you doing with the results of the queries that...