Hi,

I faced a similar problem. I was using DTS to import data from excel to SQL. It was giving error because of an Identity column in my table. It got...

Hi Greg,

I found out why that message was popping on click of parameters.

I had to add

SELECT @@ROWCOUNT AS RowsAffected

Thanks for your help 🙂

Hi Greg,

In the Execute SQL Task Properties dialog box, when i establish the right existing connection and click on Parameters button, it pops a message saying that

'The SQL Statement...

Thanks for the response.

I'm not very sure how to write a global variable into a file either. It's a start though.

It would be great if you could provide me with...