We have the same damn problem here. Our linked servers (SQL Server 2005 64bits) point to Oracle.

Did you notice that the amount of missing records is always 99?

Also, when...

In fact I'm not sure what Surya really wants to accomplish 😀

If you want to load some files from a specific folder, the task is much simpler. ForEach Loop Container...

For sure.

1. Create a new package.

2. Add a variable (i will refer to it as "Var") of Data Type "Object"

3. Add a Execute SQL Task (EST).

4. In the "General"...

Hi Surya,

that can be done with a Execute SQL Task (EST) to retrieve your file paths and store them in a variable of type Object. After the EST, add a...

Hi Daniel,

in case you don't know, you can add a Credential and a Proxy to SQL Server, so you can run a package (within a job) under an account other...