Forum Replies Created

Viewing 15 posts - 91 through 105 (of 1,118 total)

  • RE: How to break the 4000 character barrier in SQLCOMMAND.

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

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    November 26, 2011 at 7:22 am

    #1413108

  • RE: INFORMIX to 64 bit 2008 R2 windows server 2008

    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...

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    November 26, 2011 at 7:20 am

    #1413107

  • RE: Importing mutiple XSD schemas and XML files

    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...

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    November 20, 2011 at 7:27 pm

    #1410462

  • RE: Excel Workbook over 116 MB After Loading from SQL, need to Select Range & Delete to Reduce File Size

    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...

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    November 15, 2011 at 7:10 am

    #1407858

  • RE: Excel Workbook over 116 MB After Loading from SQL, need to Select Range & Delete to Reduce File Size

    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...

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    November 14, 2011 at 9:46 pm

    #1407612

  • RE: ETL Design

    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...

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    November 9, 2011 at 6:39 pm

    #1405486

  • RE: package variabel as lookup table

    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...

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    November 7, 2011 at 6:26 pm

    #1404236

  • RE: how to merge single page tiff file to multi page tiff file

    Learner1 (10/27/2011)

    Hi

    I have a requirement to merge single page tiff files stroed in a table to a muli page tiff file...

    Can I accomplish this using SSIS?

    Thanks

    For image manipulation I would...

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    October 28, 2011 at 10:14 am

    #1400712

  • RE: .PDF Image Import

    rocky_498 (10/20/2011)

    Hi guys,

    Quick question,

    How i can import .pdf Image into SQL Server through SSIS?

    Thanks in advance.

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

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    October 24, 2011 at 5:08 pm

    #1398931

  • RE: Is it possible to update a value in an xml file via SSIS?

    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...

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    October 24, 2011 at 5:01 pm

    #1398928

  • RE: Download Email attachments in SSIS

    Deee -Daah! (10/17/2011)

    Hi there,

    Did you find any solution? I have the same need.

    Thanks

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

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    October 17, 2011 at 7:10 pm

    #1395664

  • RE: Need help: Importing .SAS file to SQL Server 2008 using SSIS

    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...

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    October 6, 2011 at 10:39 am

    #1391317

  • RE: exporting data to excel with dynamic column names

    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...

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    September 28, 2011 at 7:22 pm

    #1388154

  • RE: FTP task problem - SSIS

    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...

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    September 28, 2011 at 7:20 pm

    #1388153

  • RE: Importing PDF files to Sql server database

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

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    September 27, 2011 at 8:13 am

    #1387178

Viewing 15 posts - 91 through 105 (of 1,118 total)