Forum Replies Created

Viewing 15 posts - 286 through 300 (of 1,118 total)

  • RE: Using expression in Sharepoint List source and destination

    Mahi-667326 (9/1/2010)


    Hi,

    I am trying to pass a variable to sharepoint URL and sharepoint list name in SharePoint List task, so dynamically I can look at mutiple URL's and load data...

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

  • RE: Concurrent processing in SSIS – Part 1

    Thank you for the article Elliott!

    I think you will find this related information interesting. CozyRoc has recently released a new third-party commercial task called Parallel Loop Task. What this task...

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

  • RE: Lookin for Reference for EDI Using SSIS and X12 Format Files

    Thanks for the post.

    I am aware of your 3rd party solution. I'm trying to come up with a good way of doing this without using 3rd party tools.

    Alvin,

    EDI is...

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

  • RE: Lookin for Reference for EDI Using SSIS and X12 Format Files

    Hi Alvind,

    As I understand you have found first-hand it is not easy to flatten or transform EDI data into tabular data flow format. There is a third-party commercial solution for...

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

  • RE: SSIS2008: Using SSIS for managing MySQL data

    stephanie.sullivan (8/18/2010)


    Thank you very much for the response. I've downloaded the extension pack and its working well. The table difference task and a few others are already proving...

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

  • RE: SSIS2008: Using SSIS for managing MySQL data

    Hi Steff,

    In my opinion the best working MySQL provider is ODBC. You can read from ODBC thru the standard ADO.NET DataReader Source. For writing to MySQL, check the commercial CozyRoc...

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

  • RE: SSIS package issue

    obulay-657245 (8/12/2010)


    I too have problem accessing Sybase. I am also using SQL 2008 in 64-bit environment. I have datasource to Sybase and when I process the cube, it gives me...

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

  • RE: Memory leak in SSIS package

    Hi Tom,

    Have you seen this report ?

    Also check this post and the comment below by skreekc.

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

  • RE: Code reuse in script component

    stricknyn (8/10/2010)


    Hi All,

    I have a script component which contains a function that will be used by many script components in my package. I was just looking for some pointers...

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

  • RE: How to Read TEXT data and emailing

    PaVeRa22 (8/4/2010)


    divyanth (8/4/2010)


    Do you want to read the Complete data in that field or just the 30000 characters ? If you want to read complete field i might be...

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

  • RE: Importing data using OLE DB Destination Task

    f.khan (8/2/2010)


    the instructions for a database to execute a job?

    I dont have a lot of experience in database design and SQL Server and how it works behind the scenes. I...

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

  • RE: Importing data using OLE DB Destination Task

    f.khan (8/2/2010)


    i'm not sure what you mean there Cozy.

    Currently the load process is inside a dataflow task.

    Are you familiar with the database transactions?

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

  • RE: Importing data using OLE DB Destination Task

    f.khan (8/2/2010)


    Thanks for the reply Cozy.

    I was hopeing to totaly abort the import if there was a problem rather then just redirect the error rows. So if there is a...

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

  • RE: Collation problem, exporting data to a flat file

    nailosuper (7/29/2010)


    Hi,

    I have a table with collation SQL_Latin1_General_CP1_CI_AS and i want to export from this table to a txt file with encoding : l'ISO-8859-1.

    i get this error in...

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

  • RE: Quit command

    WWL (7/29/2010)


    I have an FTP task and now I'm being told that I need to add a "Quit Command", basically The mailbox does not know if all the data was...

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

Viewing 15 posts - 286 through 300 (of 1,118 total)