Forum Replies Created

Viewing 15 posts - 106 through 120 (of 1,118 total)

  • RE: File Connection Manager Security Context

    Where do you see the error? When executing under BIDS or when executing under SQL Job Agent? If you are seeing the error under SQL Job Agent, you have to...

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

    September 16, 2011 at 5:55 pm

    #1382836

  • RE: Flat File size limit?

    Koen Verbeeck (9/14/2011)

    brodak (9/13/2011)

    did you get an answer for this?

    The only real limition is the size of the machine's memory (RAM) where the package is running on, as...

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

    September 14, 2011 at 2:57 pm

    #1381630

  • RE: Where is this package running?

    The comment by kramaswamy is incorrect. The package will execute on Server 2. It doesn't matter where it is stored.

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

    September 7, 2011 at 7:23 pm

    #1378333

  • RE: SSIS connection string password issue

    If you are providing the information from outside, then you can set the package protection level to DontSaveSensitive. This should solve the issue you are having.

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

    September 7, 2011 at 7:22 pm

    #1378332

  • RE: FTP Task

    Yes, the only other mode is binary.

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

    September 7, 2011 at 7:16 pm

    #1378331

  • RE: Need to create folder in destination location thru ftp task

    NLV (9/7/2011)

    Hi,

    I am posting one file from source location to destination location thru FTP Upload task in SSIS. While posting I want to create a current date folder in mm-dd-ccyy...

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

    September 7, 2011 at 7:14 pm

    #1378330

  • RE: To Process files on a different domain using SSIS 2005

    This is impossible with the current version of SSIS. You cannot impersonate or use domain credentials other than the credentials under which your package is executing.

    So the suggestion with the...

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

    September 2, 2011 at 6:42 am

    #1376404

  • RE: Creating dynamic .mdb files ( MS Access 2002-2003 )

    harry.sh16 (8/31/2011)

    Copy operation doesnt work for .mdb files/databases using File System Task, so how would one copy databases in the first place??

    Why it doesn't work? It is a regular file,...

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

    August 31, 2011 at 12:44 pm

    #1375632

  • RE: Creating dynamic .mdb files ( MS Access 2002-2003 )

    harry.sh16 (8/29/2011)

    Hi,

    Im trying to see if creating .mdb files on the fly is possible at all(.mdb will be my destination and i wish to create a table in it too...

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

    August 29, 2011 at 1:32 pm

    #1374680

  • RE: ssis to refresh development data from production

    akl (8/26/2011)

    when there is a database with hundreds of tables it gets very tedious to create individual data flow objects for each table. is there a way to use a...

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

    August 27, 2011 at 6:25 pm

    #1374267

  • RE: HTTP: GET from SSIS Script Task

    Hi Allen,

    Yes, this is Ivan.

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

    August 24, 2011 at 9:58 am

    #1372692

  • RE: Need help with Script task vs ActiveX task

    Hi Randy,

    Another option would be for you to learn VB.NET programming and implement your script using the .NET framework. VBS is very different animal compared to VB.NET.

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

    August 24, 2011 at 9:49 am

    #1372684

  • RE: Read multiple flat files with different formats and output to SQL Server

    If you can use third-party solutions, check the commercial CozyRoc Data Flow Task Plus. The enhanced data flow task supports dynamic data flows at runtime, so you can process all...

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

    August 24, 2011 at 9:46 am

    #1372682

  • RE: System::MachineName on a cluster

    You are using different OS. This may be the reason why you get such different results.

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

    August 24, 2011 at 9:44 am

    #1372680

  • RE: HTTP: GET from SSIS Script Task

    Hi Allen,

    I would recommend against using ActiveX scripting because it is no longer supported.

    Having said that, if you are receiving error on CreateObject function call, then you don't have MSXML...

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

    August 24, 2011 at 9:43 am

    #1372679

Viewing 15 posts - 106 through 120 (of 1,118 total)