Forum Replies Created

Viewing 4 posts - 31 through 34 (of 34 total)

  • RE: DTS works but schedule JOB don't

    Here's an idea try recreating the project, and make sure that Owner is one who has permissions to run the package, preferable the SERVER\Administrator. Otherwise I like the IDEA of:

    DTSRun...

  • RE: Deleting duplicate Records??

    That would be good in a normal world but when your talking about a DATA Warehouse and a Half dozen or more DTS Packages, on top of 100's of data...

  • RE: SQL Script

    You woudn't happen to have any examples of this would ya? Thanks. I only have one data source. (text file)

  • RE: Deleting duplicate Records??

    This is what I have so far but when I run it it deletes all the records. What am I doing wrong

    DELETE

    FROM Customers

    WHERE Customers.CUSTID IN

    ...

Viewing 4 posts - 31 through 34 (of 34 total)