The standard Data Flow Task supports only static data flow definition at design time. You...

Eric,

In OLEDB the parameters are not named . The question mark (?) is the parameter and that's what the parser processes. That's why the order matters.

sumit.hitk.ghosh (4/25/2012)

---

Can anyone please post the steps to configure SSIS package to invoke fastexport utility for bulk loading from teradata to sql server 2005? Also please let me know which...

What is specified in sharePointURL variable? I think you have some special characters, which have to escaped. Try to escape the URL, before creating the request. Try HttpServerUtility.UrlEncode method.

If you can use third-party solutions, check the commercial CozyRoc ODBC Destination component. It is part of the SSIS+ library. The component has been tested with MySQL and it provides...

Hello Amy,

If you can use third-party solutions, check...

lklein 83808 (3/6/2012)

---

I've been scouring the web and haven't been able to find a solution to this:

I have a package that receives a file from a FTP site with a...

Hi Ivan,

The standard Data Flow Task supports only static columns definition. Therefore you have to create a separate data flow for each XML file layout type. If you want to...

CozyRoc have just released SSIS+ 1.6 , which includes Teradata Destination component. It is supported on all versions: 2005, 2008, 2008R2, 2012

You can check the documentation for the new component...

Koen, I think the issue is the number of columns, not the length of a column.

In that case, there is a solution but it is a third-party commercial solution. I...

If you can use third-party solutions, check the commercial CozyRoc Excel adapters. They are part of the CozyRoc SSIS+ library. All Excel versions from 97-2010 are supported.

Shaheen,

I will leave the translation of the code from VB.NET to C# to you. The code is very similar.

Shaeen,

If the variable cannot be accessed for read in the PreExecute phase, then I would suggest you take the control of the variable value management in your hands. By this...

subahan_syed (2/2/2012)

---

Hello -

I have an SSIS package setup with excel as destination and I'm wondering if I can compress the file size prior to an email send task in the...

Hi Robbie,

Your SSIS package might not have changed, but someone did change your SharePoint authentication scheme and it no longer accepts NTLM (Windows Authentication). I would recommend you talk with...