Forum Replies Created

Viewing 15 posts - 901 through 915 (of 1,118 total)

  • RE: Help need to use For Each Enumerator

    Suresh Kumar (2/9/2009)


    Hi,

    I need to pick data from CSV files one by one from a specific folder and put the data retrieved (in each CSV file) to a table in...

  • RE: Importing Excel Files into Tables

    mrtrich99 (2/9/2009)


    mrtrich99 (2/9/2009)


    CozyRoc (2/9/2009)

    It fails because it tries to validate the data flow task, which will be setup during execution. Right-click on your data flow task and change DelayValidation property...

  • RE: Importing Excel Files into Tables

    mrtrich99 (2/9/2009)


    It fails because it tries to validate the data flow task, which will be setup during execution. Right-click on your data flow task and change DelayValidation property to true....

  • RE: Importing Excel Files into Tables

    mrtrich99 (2/9/2009)


    The attached the "ExcelError" file is the error code I get if I only have the User::Variable as the Connection String in the expression.

    When I don't use...

  • RE: SSIS ForEach FTP: Ability to pass Servername, Username, Password

    leighton_d (2/8/2009)


    I did some exploring and found the error message displayed in the "Output" window:

    SSIS package "cNotifyAbsence.dtsx" starting.

    Error: 0xC002918B at FTP Task, FTP Task: Unable to send files using "FTP...

  • RE: SSIS ForEach FTP: Ability to pass Servername, Username, Password

    leighton_d (2/7/2009)


    Well, I'm finally getting the time to work on this again. I setup an FTP task and set the connection property to:

    ServerName=ftp.cnotify.com; ServerUsername=CentralHigh; ServerPassword=Fjr3ri8t;

    When I...

  • RE: Debugging Script component

    stricknyn (2/6/2009)


    Hello all,

    I just wanted to say kudos to those people that had to endure programming when the debuggers of today didn't exist. I'm not sure I'd be a...

  • RE: Running of SSIS package on other server, say, Unix

    prsd_06 (2/7/2009)


    Hi,

    I am new to SSIS.

    How can SSIS packages be run on other servers, say, Unix?

    Earlier, I worked on Informatica & know; its workflows can be run on other servers...

    I...

  • RE: Importing Excel Files into Tables

    mrtrich99 (2/5/2009)


    I have been able to successfully import txt and csv files in a folder using a ForEach Loop, but when I use the same method to import excel files...

  • RE: SSIS SQL Job OleDB Oracle Connection Issue

    jermhillgert (2/5/2009)


    CozyRoc (2/5/2009)


    jermhillgert (2/5/2009)


    Is the server machine 64bit?

    Can you setup proxy account for your SQL Job Step and use the same account you say works properly when run manually (information...

  • RE: SSIS SQL Job OleDB Oracle Connection Issue

    jermhillgert (2/5/2009)


    Is the server machine 64bit?

    Can you setup proxy account for your SQL Job Step and use the same account you say works properly when run manually (information how to...

  • RE: SSIS SQL Job OleDB Oracle Connection Issue

    jermhillgert (2/5/2009)


    This is from the error log:

    SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "ORAP.h3549" failed with error code 0xC0202009. There may be error...

  • RE: Loop thru DTS.variableDispenser

    Alvin Ramard (2/5/2009)


    As anyone here loop thru the DTS.VariableDispenser, in a VB Script Task, to extract the name and value of all the variables in the package? I have...

  • RE: SSIS SQL Job OleDB Oracle Connection Issue

    jermhillgert (2/5/2009)


    I have a package that I use to grab data from a Oracle OleDB Connection. The package runs in BI Studio and when I deploy the package to the...

  • RE: Import data from MySQL into SQL Server

    kim.talley (2/3/2009)


    I am using the ODBC data provider. I have tried changing the RetainSameConnection property but this causes a validation error on my data reader.

    For the new ADO.NET connector, I...

Viewing 15 posts - 901 through 915 (of 1,118 total)