Forum Replies Created

Viewing 15 posts - 886 through 900 (of 1,118 total)

  • RE: For Loops

    Matthew Cushing (3/16/2009)


    CozyRoc (1/20/2009)


    Wasn't sure if you could pass an odbc connection string as a param to a for loop.

    Yes, you can. You have to store your connection string in...

  • RE: Script task no longer working

    Cheryl Reed (3/13/2009)


    So I know it's failing/hanging on the ShowDialog statement. Are there any log files I can check for further information??

    From where do you execute the package? Are...

  • RE: SSIS CSV failure to import

    wood.kieran (3/11/2009)


    Hi,

    I have a CSV file which has been generated from an Excel Spreadsheet. I have various problems importing this CSV file via a Flat File Source Data Flow Component....

  • RE: Mailing List

    rcr69er (3/12/2009)


    Hi Guys

    I have a table that is going to hold email addresses for a mailing list

    Eg.

    MailingList:

    ID, Email

    1,billybob@ipadd.com

    2,janef@ipadd.com

    3,harryk@ipadd.com

    4,evonnet@ipadd.com

    I am creating a SSIS package that is going to use the email...

  • RE: Using script to execute Python script?

    Nick (3/12/2009)


    Hi Folks,

    I am trying to simplify a multi-step process whereby data from our GIS SDE database is transformed and loaded into a SQL db.

    The first step in...

  • RE: Can You Change Flat File Connection via Script Task?

    pcapazzi (3/12/2009)


    Hello,

    I have a flat files that come in from various sources, hence they have various formats. They are all text files though and I only need one common field...

  • RE: Import excel 2007 and previous version within same data flow

    Megistal (2/12/2009)


    I need to import data that has the same output destination, a SQL table, same work and analysis to do with them through different excel version sheet.

    However from articles,...

  • RE: Tranformingand Tranfering a big file

    Edwin (2/12/2009)


    I need to transfer a big files 100 GB ++ between two locations.

    SOURCES located in the network segment A.

    DESTINATION located in the network segment B.

    Both location is protected...

  • RE: How do I pass a variable value to a query?

    Derek Dongray (2/11/2009)


    I've come up with a solution using the Execute SQL Task but it seems a bit of a kludge.

    I've changed the SQL query in the task to something...

  • RE: problem in bids

    ramu4ind (2/10/2009)


    Hi all,

    when i am opening old package in bids or creating new project(is,as,rs).it shows the message object reference not to set an instance of an object.previously it is working...

  • RE: Running multiple queries under one ODBC connection

    David Musson (2/10/2009)


    Thanks for the reply.

    I have, but as soon as I change retainsameconnection to true, the first time I try to connect to the data source in the package...

  • RE: Edit SSIS Package Configuration in common for all the similar package

    SQLBuddy (2/10/2009)


    Hi All,

    Sorry if the topic already exists.

    I have around 50 packages with the same connection string to the database.

    The package configurations are from XML file.

    Its highly...

  • RE: Send Mail Task Question

    Igor Deck (2/9/2009)


    Hi!

    Is it possible to send mail in HTML format using Send Mail Task?

    Thank you,

    ID

    Standard Send Mail Task doesn't support HTML messages. However you can create a script, which...

  • RE: Running multiple queries under one ODBC connection

    David Musson (2/9/2009)


    I'm using an ODBC driver that connects to an outside database that only accepts certain types of select statements and has row limits.

    In my SSIS package...

  • RE: Sybase DI Suite versus Microsoft SQL server 2005 SSIS for ETL and Datawarehouse

    symbiant2k (2/9/2009)


    Hi,

    what would you do if you would be confronted with the following question?

    The organisation I currently work for is searching for a datawarehousing solution to collect information from...

Viewing 15 posts - 886 through 900 (of 1,118 total)