before you pull your hair out, on the FTP thing and password, if you want to save the password you have to set a variable to be the password and...

Is the file and xls (i.e. not excel 2007/2010) file?

have you put "EXCEL 8.0;IMEX=1;HDR=No" in the Extended Properties? (No quotes)

is there any "dynamic" sql in the query? Can you change any parameters to hardcoded values as a test

Assuming you've confirmed the queries are the same through profiler...

Run DBCC FREEPROCCACHE...

Sure,

1) Create a OLE DB connection.

2) Provider is Microsoft JET (note, this will only work on x86 machine or package running as x86)

3) Set filename to be full path...

Are these SQL tasks or dataflows?

if the latter, are the queries in the DF source or have You said "use table / view" option? If that, then your problem might...

why not try with hardcoded values and get it working that way? The move onto the expressions to make it dynamic? 😉

Seeing as I am back in the painful world of Excel....

Try using a OLE connection to the file, add "EXCEL 8.0;IMEX=1;HDR=No" in the extended properties and select from the connection...

This is off topic but there you go...

Can you run the package when saved as a file and not in MSDB?

I've no experience on running things from MSDB (There is...

When you say you can run the package manually, do you run it under the same account as Agent or your own user?

For so many reasons I and others have mentioned - do not use the table. ALWAYS use a select col1, col2, col3 from table.

Search the forum or google for...

Try running a bat file via telnet?

Another way would be to run a file locally which connects to SQL which uses CMD to run a file local to itself. Butt...

You cannot.

Checkpoint files restart from a certain task. A dataflow is a task. You cannot restart from point withing the dataflow. Think how much custom logic that would require.

If...

oxfield (8/27/2008)

---

I have a similiar issue Paul, I need to load from excel where the columns will vary on each import into an OLEDB destination. I have been wrestling...

Paul_J (8/24/2008)

---

Crispin Proctor, you said:

"You could do it with BCP but your table columns / file columns will have to be aligned".

Are you sure of this? I thought that's exactly...

The sort task is the only stock component that can do a, well, sort.

There are other tasks out there that you can buy (nSort for one) that are better. But...