Viewing 15 posts - 61 through 75 (of 1,117 total)
SQL* (5/31/2012)
Hi All,How can we loop through multiple excel files if they are having different schema.
Thanks
The standard Data Flow Task supports only static data flow definition at design time. You...
May 31, 2012 at 8:43 pm
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.
May 12, 2012 at 6:51 pm
sumit.hitk.ghosh (4/25/2012)
May 4, 2012 at 6:27 pm
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.
March 26, 2012 at 4:40 pm
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...
March 24, 2012 at 6:13 pm
Amy.G (3/12/2012)
I did figure out how to add a reference, but will still take easier methods for reading a zip file in SSIS.
Hello Amy,
If you can use third-party solutions, check...
March 12, 2012 at 12:05 pm
lklein 83808 (3/6/2012)
I have a package that receives a file from a FTP site with a...
March 9, 2012 at 10:12 pm
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...
March 5, 2012 at 11:07 pm
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...
February 28, 2012 at 8:01 pm
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...
February 27, 2012 at 11:37 am
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.
February 27, 2012 at 11:30 am
Shaheen,
I will leave the translation of the code from VB.NET to C# to you. The code is very similar.
February 6, 2012 at 7:52 am
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...
February 3, 2012 at 12:39 pm
subahan_syed (2/2/2012)
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...
February 2, 2012 at 8:45 pm
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...
January 18, 2012 at 7:47 am
Viewing 15 posts - 61 through 75 (of 1,117 total)