This is not the correct place to post this question. Try here or here.

What's happen with this issue? Did you make it work?

Eric,

You have to quote the complete parameter and double quote, the quotes inside.

Try this:

DTEXEC /DTS "\MSDB\MyPackage" /SERVER "ERIC" /SET "\Package.Variables[User::ConfigDbConn].Value;""Data Source=whatever;Initial Catalog=MyDb"""

or this:

DTEXEC /DTS "\MSDB\MyPackage" /SERVER "ERIC" /SET "\Package.Variables[User::ConfigDbConn].Value;\"Data Source=whatever;Initial...

phina_el (1/24/2010)

---

Hi everyone...

I m trying to run ssis package from SQL SERVER AGENT, and it give this error:

Message

The job failed. The Job was invoked by User sa. ...

NERO (1/22/2010)

---

Hi

I am planning to transfer data from a source Excel spreadsheet to another desination spreadsheet. But I need to create multiple lines in the destination from a single line...

imani_technology (1/22/2010)

---

I am trying to use SSIS to import a text file into an Oracle database. However, I get the following error:

"Test connection failed because of an error...

Brad,

You have to...

Brad Johnson-378105 (1/28/2010)

---

I have not gotten it to work yet, but I did figure out that I had to include the port number with the servername i.e. KRMSDEV:446. The...

There is solution based on the third-party commercial CozyRoc SSIS+ library. CozyRoc has implemented data flow destination script, which creates memory-efficient range dictionary object. The dictionary object can then be...

Jack,

Is it possible to query multiple GUIDs using this custom DLL library? If that is the case, you have to change your script a bit making it asynchronous and buffer...

Check this discussion.

This sounds like a nice workaround. However this situation looks like a bug to me. Have you tried reporting this problem to Microsoft?

You have to setup your source SQL statement to provide the date as string in the data flow. Then use standard Data Conversion transform to convert this string column to...

yosiasz (1/19/2010)

---

Greetings!

How can I use a Data Flow Task to read an Excel file and write it to a named sheet in my destination workbook? I am trying to create...

maryam7756 (1/19/2010)

---

Hi Experts!

I have a SSIS Package which is creating a flat file from a table in my db. and it works great.

but I have over 360,000 records in it....