What is the error when you run your code? If your string contains backslash, you have to escape it like this:

StartInfo.FileName = "C:\\Program Files (x86)\\Microsoft SQL Server\\90\\DTS\\Binn\\dtexec.exe"

There are two options to execute your package in 32 bit mode:

- make the executable, which contains your library to execute...

Use derived column transformation to convert the failing column.

CorinaThong (12/20/2009)

---

Hi CozyRoc,

Thanks for your reply.

I got the following error from the SSIS package log:

The AcquireConnection method call to the connection manager "QuickbooksExtract" failed with error code 0xC0202009.

where the QuickbooksExtract...

This is the error stack dump and it is not helpful. Can you setup your code like this:

Dim reader As SqlDataReader

Try

reader =...

Is there an error when you execute your package from code? If yes, what is the error?

Helical Johan (12/17/2009)

---

Hi, I have a process task. I execute a jar:

Name1 = c:\helical.asc

Name2 = c:\files

Name3 = hello

java -jar nombrejar.jar -d + @[User::Name1] + @[User::Name2]+ @[User::Name3]

My problem is when some...

Oblivisci (12/17/2009)

---

I believe I already no the answer to this but I will ask anyway.

Is it possible to use a query on a SSIS package that is stored in the...

namrata.dhanawade-1143388 (12/17/2009)

---

OK. I know about the connection manager now.

However in a Execute SQL Task; I want to delete rows from a table in the Access database for which the Jet...

namrata.dhanawade-1143388 (12/17/2009)

---

Hi

I want to export some dta from SQL to a Tbale in the Access database.

I am not sure what connection manager should be used.

Also, what syntax should be...

wcwarner (12/16/2009)

---

Hi,

I am developing an SSIS pkg that will be connecting to a mainframe using an ODBC connector. The cODBC connection is very limited in the number of connections...

True - but then why is SSIS and SQL server 2005 is rubbish at importing and exporting CSVs.

Perhaps I agree on the easier to understand point and a...

da-221236 (12/15/2009)

---

Hi,

If I understand properly - you dont mean what langauge to use in SSIS but rather whether to go with pure .NET vs SSIS. Am I correct.

We...

The DTSX files are not executables. It is more like the .doc file, containing description of your work flow. There is no way to execute SQL 2005 packages, unless you...

Can you post a sample Excel file with the issue?