The info we've brought out on the thread so far does not compute. There is some other variable affecting the behavior that is missing. I'll step aside and see if...

How are you connecting to the DB instance, with Windows Auth or SQL Auth?

And just to confirm, you're opening SSMS and BIDS on the same machine using the same creds...

I see "for 64-bit" and "Provider cannot be found." in the error message. It could be that the OLE DB provider teh package is trying to use is 32-bit only....

Adding sample package (SQL 2008 R2) as attachment in case there is interest.

Jeff Moden (9/20/2012)

---

opc.three (9/20/2012)

---

You could do this in a Script Component in a Data Flow setup as a Destination. Keep a counter in your code and issue a new CREATE...

only4mithunc (9/7/2012)

---

Thanks Brandie,

But here in our case we are not sure of the out put column names. Based on the parameters what we pass to the SP, the out put...

Jeff Moden (9/20/2012)

---

opc.three (9/20/2012)

---

The less attack surfaces the better. If you're only worry is against the SQL-ninja then sure, nothing will stop them. The higher we raise the bar for...

SSIS Email Source Adapter by Pragmatic Works

Third-party tools or Script Task.

Measure total server memory used by SQL Server:

SELECT cntr_value / 1024.0 AS TotalServerMemoryMB

FROM sys.dm_os_performance_counters

WHERE counter_name = 'Total Server Memory (KB)';

For physical (if VM host is stealing) and...

What is running your SSIS package? A job?

Extended Events session that writes to a file? The volume should be low enough that you can get away with later writing the file to a table or load up...

stevro (9/20/2012)

---

Yes,...

moving-parts

Why let the package that checks for the record exit? Just let it run. This way you would only need on SSIS package.

There are lots of options but here are...