I Just recently posted a blog post on this: http://blog.cybner.com.au/2008/05/unzip-files-using-ssis.html

Hope this may help 🙂

I resolved a similar issue by using a parameterised Lookup - but there are a few things to look out for if you do this...

1. SSIS really doesnt like parameters...

Hi Makko,

Noel is right. If your using Merge replication & havent marked the article as download only there is no reason why the data shouldnt be going both ways. Check...

my faves are:

http://www.sqlis.com/

http://www.sqlservercentral.com/

http://sqljunkies.com/

http://www.ssistalk.com/

You may just want to check that when you deployed your packaged you selected to deploy to SQL server & not the file server. This should be a very simple...

If you dont want to pull each of the packages in individually & the SQL 2000 box is still online, you can use BI Studio to migrate the packages as...

well thats good news! I hate to give advice that is incorrect! 😛

This can also be affected by how you refer to objects outside of SQL (such as files) or even passwords that may be stored within your package. Make sure you...

Active x script tasks are provided for backwards compatibility only. In fact I believe they are being deprecated in future releases.

Try using the Script task instead. It provides a...

I had a similar problem when the collation between the distribution & pubs database was different. I was able to change this in my system setup & it fixed the...

If you want to see the packages you have created & deployed within SQL Server, connect to server type of Integration Services rather than Database engine either when first opening...

Hi Patrick,

When you create your connector for the import file, it actually defines the column types for each of your columns of data from the input source selected. Check the...

Hi Julian,

I can understand why this is causing you some confusion as it is not blatantly obvious - but you are able to type over where it says "Master" and...

Hi Scott,

You could use a conditional split - i.e split out all the rows that have the value you are looking for in the product field - then pass that...

It is quite touchy about the datatype you are looking up. Try to make sure the data type is the same for what you are passing and the matching field...