Just curious why you wouldn't simply specify that the call is a stored procedure and then add the input parameters.

Enter the scheme.name of the procedure and specify Is Stored Procede...

I have a similar post to this but mine is reading a file. Anyway the UNC path would be something like this

\\mysite.com\subsite\....\docLib\myfile.ext

Do this through windows explorer to see if you...

You can check if the job is running before executing it. Let me know and I'll post the code.

If I'm understanding this, you want to give someone the ability to call a stored procedure with a couple date parameters that you can then pass into an SSIS package.

There...

thanks for the info. Installing 2008 right now.

In my source components I always use SQL statements for the source query, this is where I would have put the alias. HTH - tom

We are still waiting on MS for an answer. My understanding is that this is caused by a for each loop which we have inside the for loop. I have...

We are working with Microsoft on this issue. I sent them the link to the connect bug (thanks again Cozy Roc). I'll update with any useful info or hopefully...

Thanks for the info. This package uses a for each within a for loop. I think I'll remove the for each and just use a script component.

The problem here has nothing to do with SQL Server this is an SSIS issue of memory leak. The high CPU is still a mystery but we think it has...

Can you run the package in bids? can you do a preview from the data source component?

how are you connecting, SQL Auth or windows?

what type of connection manager is it?...

not exactly sure what you are going after here and this response may be elementary but when in a data flow double click the arrows between the components and select...

Installed process Hacker. Not sure what to focus on. this morning the server was CPU bound for about 5-10 minutes. this appears to coincide with a sharp drop in page...

thanks for the info Leo,

we are running a single Intel Zeon 2.33 GHz on a 32 bit vm with 4 GB RAM

Server 2003 R2 Standard SP2

SQL 2005 SP3 32 bit

Primary...

Thanks for the replies. We just had another occurrence and this time we were able to shut down the sql server and agent. Also no ssis jobs were running.

The...