Yes, it should be. I just wanted to make sure it was....

When the tables were linked, was the "Save password" box checked"? I had the same problem happen to me until I deleted them and re-created the links.

Did you ever get this resolved? I execute DTS packages from my .NET application all of the time without any problems.

Here is another link that may help. I've used this a few times thanks to another member's input:

http://www.sqldts.com/default.aspx?254

Good luck, Sandi

Thanks for your replies. I've actually solved the problem - I think I deserve the headbanging I was taking after this one...

In my .NET code I neglected to code the...

Don't know if this will make a difference, but instead of using SELECT INTO, FROM, try using INSERT INTO, SELECT FROM.

Example:

INSERT INTO #Temp Table (col1, col2, col3, etc)

SELECT (col1, col2,...

That worked!!! Thanks for your help Mike - that's a neat workaround.

Sandi

Hi all. Sorry I haven't replied - just returned from a short vacation.

Mike,

Thanks for the suggestion. I'll try it as soon as I can unbury myself from the...

Mike,

I'm sorry, but I gave you the wrong info. I'm not doing an Execute Sql Task, but rather using an exec SQL query in the Transform Data Task Properties which...

Another option is to create a stored procedure in SQL that will bring back your complete recordset. Bring in the recordset through your application, and then use the rowfilter property...

Hi Mike,

Yes, I am calling a stored procdure from an Execute SQL Task. The parameters match: the first one is date in DTS and datetime in SP. The second one...

The package has the global variables set. The package itself has the errors. It's a step error, and the step error description is "The parameter is incorrect."

No, I haven't. I'm not sure how to run a package with global variables(with different values than the ones it's set to in the package).

Sandi

You can do this in the reports designer. Under the special fields section, insert the print date in the page footer. Then format the date. One of the choices is...

Glad you got it working