If you open the OLE DB Destination component dialog, there is a selection called "Error Output". The default is to fail the component, in case of errors. You can change...

quasar_phoenicis (7/22/2010)

---

hi,

I'm trying to create an SSIS package that reads an email from MS Outlook 2003 (using the subject as the criteria) then save the excel file attachment of that...

WangcChiKaBastar (3/16/2010)

---

I have to modify an existing package to enable parallel processing (multi threading) package currently processes flat files and dumps them over I need to enable process where it...

sqlfavor (4/7/2010)

---

I have identical source databases(SQL Server) that I want to perform parallel ETL into single DW. The number of source databases can vary, so some sort of dynamic connection...

I have shared everything you need to start working...

Hey,

People are on vacation... come back in September 😉

Just silly joke.....

Barkingdog (7/20/2010)

---

SSIS 2008: I have a user-defined string variable (contents created at run time....) which contains

concatendated "lines" of data, each terminated by a carriage return line feed. I want to...

Have you tried using the standard DataReader Source component?...

Check here for programming sample how to get current machine IP address. You can easily convert this into SSIS script.

It was stated a couple of lines below. The original post was made long time...

If you can use third-party solutions, check the commercial CozyRoc Data Flow Task Plus. It supports combination of static/dynamic data flows and doesn't require programming scripts.

npothineni (7/7/2010)

---

Hi Everyone..

I am looking for incremental load i got this link to achieve scd.Here they did with table difference,Is there any transformation for table difference in ssis 2008.please let...

sridharparshi (6/28/2010)

---

all these flat files are different from each other and destination tables are also different for every flat file

so now i got some idea like looping through the all...

Verify what is the type of connection you are using. This doesn't look like ADO.NET connection.

smacumber 77733 (6/25/2010)

---

I was able to create code using Script Task to receive files from FTP site and then delete them, now I need to decrypt these files I brought...