I don't have....

M Shah (3/17/2010)

---

I am copying data from one SQL server instance to another SQL Server 2008 instance using the dataflow task and using OLE DB connections. The data move...

Jay Gamblin (3/16/2010)

---

Just when I thought I had gotten away from vbscripts and moved on to better technology someone changed the Maxpagesize setting in AD back to 1000 rows. ...

duanecwilson (3/16/2010)

---

Can I use SSIS to import a csv file directly to a table destination? It seems like the FTP task just allows the destination to be a file, which...

This is in NO WAY going to be easy to resolve manually because this is a mess. The easiest solution at this point is to reinstall SQL 2005 Integration Services...

Is it possible to copy the file to a local drive and then process it from there?

asukitta (3/15/2010)

---

Data conversion failed. The data conversion for column "MR_E" returned status value 2 and status text "The value could not be converted because of a potential loss of data.".

...

Where do you get this error? SQL Job Agent, console execution.. ? What is the package protection level set to?

Have you tried to use standard Pivot/Unpivot transformations?

On 64bit machine there are two version of the ODBC adminstrator application. I suspect you have used the 64bit version and the system setup was made in the 64bit branch...

I can only say I feel pity about you. The Sybase client software is extremely buggy and incomplete. Until Sybase decides to fix their software there is very little you...

Right-click on your project select Properties menu. When the properties pane opens, click on Compile tab and then click 'Advanced Compile Options...' For Taget CPU , select x86

I don't want to be rude, but you cannot expect people from the forum to do the translation job for you. You have to either learn how to convert the...

Have you tried to compile your application as x86 (instead of AnyCPU) ? This will force your application to be 32bit and you will be able to avoid the Excel...

xnl28-574517 (3/2/2010)

---

Hi,

I have a recordset in my package populated with the TypeIds of data I want to include. Now I would like to use a Lookup task to identify those...