Does you XML file have something like this on top:

<?xml version="1.0" encoding="utf-8"?>

This is what controls what encoding should be used to read your XML file. Without it, the reader doesn't...

sas (7/14/2009)

---

Hi,

I have modified the Script Task of a packagge Programatically, but nee to know how to precompile the script as the Precompile property is set to true.

is there any...

archiemonga (7/12/2009)

---

Btw, I should mention that we are not supposed to change table structure as it is created by an application. And once the records have been added, the table...

archiemonga (7/12/2009)

---

The select (same one) statement without ORDER BY should give results in order that records were physically added since there is no primary key and index set on the...

Your test is not conclusive and it doesn't proof the insertion order is incorrect. There are no guarantees in what order a relation database table will return the rows, when...

How do you know the insertion order is messed up in the data flow? How do you detect this? Do you simply do a SELECT against the result table?

Find out what is the specific type of the method parameter you want to fill-in . Then use variable type, closer to what is expected. You are trying to pass...

One possible solution is to use environment variable, which you will setup once on each server where your packages will execute and will contain the path to your SSIS packages.

Florian Reischl (7/9/2009)

---

Sorry, I recognized that this is the "SSIS Forum" after I posted my answer...

Since I'm primary a .NET developer I would use wild-cards within the scripts and a...

The way the SSIS handles package configurations is not very useful. Whenever you use the configuration wizard, it will always overwrite the existing file and you will loose all your...

This question is not related to SSIS. I would suggest you ask your question here.

This is duplicate post. The question is being answered here.

This is duplicate post. The question is being answered here.

keywestfl9 (7/8/2009)

---

i created an execute sql task and taking the particular column i need and storing it to a package variable(user::people) with datatype as object

Then i have a for each...

Try to extract the package to a file and then import on the other server to the SSIS store.