You need to change either the cursor location to client side or the cursor type in order to get a recordcount. Here is an link that explains it: ...

Maintenance plans are stored in the msdb database. If you want to move the package you can go to SSMS -> Object Explorer and click Connect -> Integration Services....

What happens when you tun the job manually?

You could generate the script, verifying that I have everything I expect and then drop the job and re-create using the script.

What do you mean by disappeared? They do not show up in Report Manager? You can't edit them anymore in BIDS?

Do you have the ability to put a trigger on the table and log the user name of the person doing the update (using suser_name())? Or can you run a...

This does not use SSIS, but is simpler than the cursor solution and should be efficient as it is set based:

[font="Courier New"]-- create table variable for test data

DECLARE @table1 TABLE...

My previous employer was a 24x7x365 manufacturing company and I was part of the rotating call schedule. The plant at which I worked was actually owned by 2 companies...

hi jack

I am really thankful to u for sending ur valuable time for my query....... [Smile]

i need the output like this...

You should be able to modify the code provided to return the results you need. And I actually answered your original post exactly as asked. Here is what...

Well, apparently we all misunderstood your question. I think I understand now. You want to find out what all the Foreign Key constraints are in your database and...

The issue is around access to the FoxPro share. The SQL Server Service Account needs access to the share. As soon as I run my SQL Server under...

I am logging in as a SQL User as if I log in using Windows I am a sysadmin and I know I have rights to the directory.

I am on...

You can probably use the Rank Function, but because you don't care which of the remaining rows you return ranking is probably unnecessary.

Mine will likely be slightly different as the only Foxpro data I have access to is in free tables so that's all I know. Here is the linked server...

I meant what you get when you open the OLEDB Destination for edit, but this actually gave me what I was interested in, since you are outputting errors to a...