If you have this option available, start using SQL 2012 RC0. The 4000 character limitation has been resolved in it.

Phil Church (11/22/2011)

---

I'm looking for an ODBC or ADO.net driver that can access an Informix database from a 2008 R2 database running on windows/server 2008. Any idea how I...

alladiz (11/17/2011)

---

Hello Members,

I need to import multiple xsd schema's and multiple xml files into the sql server 2005 db. Can this be done using ssis package ? Is there any...

Welsh Corgi (11/15/2011)

---

CozyRoc (11/14/2011)

---

Using Excel automation API is not very good idea for many reasons.

If you can use third-party solutions, check the commercial CozyRoc Excel Task. It supports deletion of...

Using Excel automation API is not very good idea for many reasons.

If you can use third-party solutions, check the commercial CozyRoc Excel Task. It supports deletion of columns and/or rows...

gugan_ta (11/7/2011)

---

Hi All,

Designing ETL to extarct 82 tables from source to staging. We have two option, pls suggest which will be the best approach.

Option 1 : Single package with multiple...

radb4u (11/3/2011)

---

Please let me know, how can I use package variable (populates GUID table), for lookup. I need to check the data in the GUID table and decide the data...

For image manipulation I would...

If you are trying to extract an image from inside the PDF document,...

Griffster (10/24/2011)

---

I want to update a value in an xml file (a variable value in a xml configuration file actually for a SSIS package), and was wondering whether it was...

If you can use third-party solutions, check the commercial CozyRoc Receive Mail Task. It supports both POP3 and...

hydbadrose (10/6/2011)

---

Please help me find the solution to import the .sas dataset to sql server 2008 using SSIS. Is it possible if so then which data provider should I use...

bhatiamadhur (9/28/2011)

---

There will be 15 columns total.. out of this 5 columns will have columns names as 2011_Q1, 2011_Q2.. like wise...Thus there will be 5 columns which will be dynamic

Please...

Did you provide the package decryption password in the SQL Job Step setup dialog ? You have to select "Operating System (CmdExec) job step type and include the password to...

The solution in SSIS is to use the standard Import Column transformation.