• Unable to execute the saved SSIS package.

    I have two servers server1 and Server2 both has SQL Server 2005 installed.Server1 has Enterprise Evaluation Edition SP1 and server2 has Workgroup Edition SP2.Since server2 has workgroup edition I cannot open the saved SSIS package in server2. So I connected from server1 created a DTS package and...

    MNA20 pointsBadges:
  • Linking SQL Server databases to create DTS packages

    I want to create a DTS package in SQL Server for the following problem: 1. Table T1 in Database DB1 in server1. 2. Table T2 in Database DB2 in server2. 3. Table T3 in Database DB3 in server3. The DTS package will be created in DB3. I need to copy data from T1 and T2 based on T1.ID = T2.ID, from the...

    SQL Server Ask the Experts2,585 pointsBadges:
  • DTS error after deleting xls file with script

    All, After I have deleted a xls file using an ActiveX script the DTS Package fails because the file is not there. I then have to go into the properties of the task and go to the destination tab and click the create button. The I have go to the Transformation tab and then run the package for it to...

    Gdckboyer20 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.