Password property issue on DTSRun Action

FinalBuilder Discussion
1

Hi,

I was using the DTSRun Action to import a table into my database. And I want to specify the connection properties such as database username and password using existing variables in the project. Is this possible?

Thanks!

2

Hi Liang,

Thanks for your post.

Variables are expanded for both the username and password on this action, so if you uncheck the “Use integrated security” checkbox and type %MyUserNameVar% for the username and %MyPasswordVar% for the password, this should work. You won’t be able to see what you type for the password, but you will get code completion for the variable name.

Regards,

Angus

3

Hi,

Thanks very much for the reply. But I still have a few questions on this action.

I have created a .dts file from a database table and I want to import the table to the target database using the .dts file. So in the DTSRun action where would you specify the destination database info? Should I enter the destination database name into the "Server 2000 instance"?

Also, since I have the dts page stored in a .dts file. Should I leave the "repository database" box empty?

I've tried the help file comes with the software and I didn't find much useful info on this action. Please help me with this.

 

Thanks!

4

Hi Liang,

As far as I understand it, the target database is part of the DTS package and cannot be changed when re-importing a package. This is different to the Repository Database property, which can be used to source the DTS package. This is a limitation of the DTSRun tool which we use to execute the DTS package.

The "Server 2000 Instance" is for the name of the SQL Server instance, when connecting to a server with multiple running instances (I'll change the label so it's more up to date.)

Regards,

Angus

5

I have now decided to use the bcp command util to import the table because with this way I can specify what database the data goes to.

Thanks for the help!