Can you connect locally (on the machine itself)?

Can you connect by IP and not name?

Can you stop and start the SQL service? If it fails to start the windows log may be helpful.

You can read the file name information into a record set destination putting it into the columns you need. The for each container can then iterate the record set...

Just a thought:

It is also extremely easy to do this with SSIS. This would give you more options and might be easier to reuse.

Is this on the same machine?

I believe when you use the execute SQL task like that is uses the permissions of the service running SQL server for authentication. Does the SQL server users have authority...

1. You can script the SQL agent jobs to move the jobs by editing the appropriate fields.

2. You do not have to keep the packages in the SQL server but...

I think it is safe to say based on all of the scripts here we have all found maintenance pplans flaky and have developed methods to get around them.

Alan

Sorry I'm slow to answer but you can use SQL with the data source by selecting it in the drop down.

In the dataflow task the SQL operator is called the...

As long as we are providing our file delete scripts here's mine. Note: this does not clean up the backup histories in the database which should also be in a...

I agree with the others I am confused about the DTS thing and you can ignore this if you are still using DTS. In SSIS you can execute packages from...

The data conversion tool make a new column called cop of [column name]. This column is the one you need to insert into the final table as it should be...

1. Yes it is in the data flow task you have created...

rew-370421 (2/8/2010)

---

Thanks, Alan.

But what do I do about

Now I'm getting CONVERSION ERRORS that I did NOT get in SQL 2000

"CANNOT BE INSERTED BECAUSE THE CONVERSION BETWEEN TYPES DT_R8 AND DT_I4...."

Also,...

A couple of answer I think that will help you.

1. You tell the connection manager that the first row contains header information and it will name the columns for you.

2....