Check the Zip Task. It is part of the SSIS+ commercial library, which includes many other...

stricknyn (1/27/2009)

---

Hi all,

I have a dataflow (We'll call it Audit) which performs some audits and sends the "good records" to one flow and the bad records to an output file.

I...

riga1966 (1/27/2009)

---

I tried SQL Server Destination component

and got an error:

Could not bulk load because SSIS file mapping object 'Global\DTSQLIMPORT ...

george sibbald (1/27/2009)

---

thanks for the reply. Please bear with me -

I've gone for option one but have hit the following problems:

I set protection level at encryptsensitivewithpassword and set a...

riga1966 (1/27/2009)

---

I also noticed in my OLE DB Destination

in "Data access mode" I used "SQL command" option to make mapping easier so that

I only see the columns to which I...

riga1966 (1/26/2009)

---

I have a Data Conversion Task

that converts data from raw table SRC_CUSTOMER where all the fields are varchar(255)

to real data types. Then the records that passed the conversion

get inserted...

If you use "Execute SQL Task", setup your SQLSourceType to be Variable. Specify the...

george sibbald (1/27/2009)

---

Hi, I am a noob as far as SSIS is concerned so go easy on me.

I have set up a transfer login task between two servers, both of...

Jagger (1/26/2009)

---

Hi,

Is it possible to use integration service in order to open excel 2007 file, then to refresh all data (pivot tables ), rename file with current datetime and...

lucky (1/23/2009)

---

CozyRoc (1/23/2009)

---

lucky (1/23/2009)

---

CozyRoc (1/23/2009)

---

lucky (1/22/2009)

---

Thanks Ray for...

lucky (1/23/2009)

---

CozyRoc (1/23/2009)

---

lucky (1/22/2009)

---

Thanks Ray for replying back.

As...

lucky (1/22/2009)

---

Thanks Ray for replying back.

As mentioned in...

Damien (1/21/2009)

---

Hi Guys,

I have been trying to find out how to access the properties of one component from within a script task. Below is more exact scenario:

I have a...

DBUSER (1/21/2009)

---

Hi,

I am new to SSIS 2008. I worked on SQL Server 2000 DTS packages a while ago.

I would like to know what will be the best...

steveb (1/21/2009)

---

I am trying to build a SSIS package that will check out a http url for a zip file, this file should be then downloaded and then transferred...