I'm having the same problem, and have been posting about it on the SSIS and general SQL Server forums.

I haven't got the option to run anything on the remote server,...

This isn't an SSIS problem, which is why I moved off the SSIS board.

I am working in SQL Server Management Services and writing an ad-hoc query. It's just a...

What I don't understand about this is why there is an expected size of 100.

I have deleted all reference to the linked server, so when I reinstate the linkage, surely...

The width of column short_description on the linked server has been changed from 100 to 1024. I have a package which extracts data from the linked server and stores...

Moving down the list of queries and beginning to panic as no answer.

If this isn't the right forum for this question, or if more info is required can someone please...

My OLE DB Source Input and Output properties tab, in the Advanced Editor has the offending column in OLE DB Source Output External columns and Output Columns, and I can...

Thanks for this. You're so right about it being sensitive!

I was not delaying validation or anything like that, and I had already tried changing the settings in the advanced...

But I can't pass the user and password to it, right? I have to have access?

That's not an option, I've been told.

It's running on a domain account.

This isn't an area of expertise for me. I lifted the code to do this from an Access program that simply assigns a drive...

Thank you for your response mmenser.

I've actually just managed to get it to work, without bringing the common package into the project.

I didn't post all 3 config files because there...

I've posted this twice here, and once in the general section. Quite a few views but no responses.

I've been trying to crack this on my own since yesterday. ...

Cheers, ALZDBA, you're really trying to help out!

I tried scripts yesterday and couldn't make them work either.

I know I'm thick but I've got a course scheduled at the end of...

I've spent the morning trying to make the proxy work, to no avail. I'm really too new to SQL Server to understand how this works properly.

I know the code...

Hi Amith

I'm pretty new to this but I have been building a package with an Excel destination, and it has automatically overwritten the file every time.

I'm not sure if this...

SQL King (3/6/2008)

---

When you did the package, you said that you don't have problems with it in your local machine. So, can I assume that you have followed each step...