You can set the properties of each task of a SSIS package to either fail the package or allow it to contunue even if errors are found. Perhops you had...

Just a thought - Are you encrypting the packages when you load them into SQL so the connections strings are stored correctly?

I had a problem with this once where the column seperator was also adding a carriage return to the output. It was hard to find as it was in the columns...

Hi Matt,

I am just curious as to why you are using a CLR for this and not just a user defined function? You can use the xp_FileExists function - for example:

It means that cab file that you have created.

When setting up your subscriber set that you will load the snapshot from an alternate location and point to the cab...

try this link:

http://sqljunkies.com/WebLog/ashvinis/archive/2005/06/15/15829.aspx

or try searching "UPSERT" or "SSIS Insert & Update" on Google

You may want to try getting the data to a desktop version as it is a bit easier to work with to test that everything is all up & running OK.

I...

looks like my last post didnt save so am adding again - apologies if it comes up twice!!

You may need to consider that you would not want to update every...

Hi Jeff,

I use a similar style function to show a random product from the10 most recently listed on the front page of the website.

Thanks for the suggestion! It was actually that the user I was using was locked out on the computer the file was located on. When I tested i was using...

No worries! Glad I could help!