Set up your data flow tasks (or multiple source/destination combinations therein) without any precedence constraints so that the beginning of one task is not dependent on the completion of another....

Strick,

Try downloading MSXML6 and repairing your installation of same:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=427145&SiteID=1

hth,

Tim

Tony,

Welcome to SSIS. You might be able to use the flat file source, but you're going to need to stage the data in a staging table to flatten it...

Geoduck.... I think my wife drove one of those back in college. Great gas mileage...

You people have lost your bloody minds. Axes and broadswords, intoxicated nuclear powerplant technicians, flatulence during job interviews, and something about a pork chop (what was the deal with...

You say that it worked fine "before".... has something changed in your environment or in the package?

Is it possible that you're sending more rows than Excel is capable of...

Like anything else in SQL, there are a score of ways to do this. :hehe:

If you are enforcing uniqueness on the target table with a primary key or unique...

You bet... what you want is the Data Conversion component. Stick it between your XML source and your SQL destination in your Data Flow, and you can convert Unicode...

You'll need references to Microsoft.SqlServer.SMO and (usually) Microsoft.SqlServer.ConnectionInfo.

hth,

Tim

Can you use a batch process to check the status of the connection? If so, use another batch file to check the status, force it to fail if the...

You are correct; a match found at the beginning of the string would result in a negative length for the outer SUBSTRING function, resulting in an error.

Have you tried bouncing the SQL AGent service to make sure that the domain account this uses (assuming it's a domain account) is still valid and the password hasn't expired?...

Are you running any transformations on your data between source and destination? Are there any possible network connectivity issues between your workstation and either the source or destination server?

Tim

If you are running scheduled SSIS jobs, you must have the SSIS service started on the server from which you run the jobs. If you run your packages manually,...

In the SSIS data flow task, there is an XML Source component which allows you to specify your source XML file and optional XSD schema. From there you can...