Forum Replies Created

Viewing 15 posts - 46 through 60 (of 128 total)

June 21, 2012 at 8:30 pm

#1504322

  • RE: Importing an excel sheet with scattered data

    Hi SJanki

    I do not know if you resolved your issue already, if you haven't the following package handles the problem you described, the data flow picture below drives the explanation.

    PROCEDURE

    a....

    Hope this helps,
    Rock from VbCity

    June 21, 2012 at 8:12 pm

    #1504321

  • RE: How to pass excel file name using a variable

    Yes, that's correct, it could mean a lot of work for you updating any package with Excel data sources based on the old driver (Xl-2003) and people at your site...

    Hope this helps,
    Rock from VbCity

    June 20, 2012 at 5:02 pm

    #1503717

  • RE: Call web method from script task

    Hi Juls-195136

    You may use an Script Task component to consume the Web Service, but you also have the Web Service Task, which is better; I found the following article at...

    Hope this helps,
    Rock from VbCity

    June 20, 2012 at 9:21 am

    #1503532

  • RE: FTP Task: 'The password was not allowed'

    I ran a test on my workstation before posting my suggestion, I was chasing permissions problems, I did not try to use my local server because FTP permissions issues are...

    Hope this helps,
    Rock from VbCity

    June 20, 2012 at 8:44 am

    #1503493

  • RE: Excel OLE DB Source failed with error Message Opening a rowset for sheet1 failed...

    Hi Sandy

    Is this the same problem you reported at the Integration Services forum?

    Hope this helps,
    Rock from VbCity

    June 20, 2012 at 2:37 am

    #1503272

  • RE: Cannot create a connection to data source ''.

    Hi Erics

    It could be possible that your data source is either [a] not deployed or it was deployed and still referencing the developer environment.

    You can check it out by...

    Hope this helps,
    Rock from VbCity

    June 19, 2012 at 8:52 pm

    #1503204

  • RE: SSIS Package not following error path

    Hi GRussell31

    I can't explains why your data flow is not following the error path, I can suggest the OnError event at Package level? you can set it up at the...

    Hope this helps,
    Rock from VbCity

    June 19, 2012 at 8:16 pm

    #1503195

  • RE: FTP Task: 'The password was not allowed'

    Hi cafescott

    I tried to replicate your issue on my workstation, I set a local FTP server and it worked fine, I had some password rejection because I did not enabled...

    Hope this helps,
    Rock from VbCity

    June 19, 2012 at 7:53 pm

    #1503191

  • RE: How to set the environment variables for SSIS package

    You may use the SETX variable value command in a DOS or CMD batch file or console; I did not try this on a secured environment, it does work on...

    Hope this helps,
    Rock from VbCity

    June 19, 2012 at 12:12 am

    #1502582

  • RE: Pulling data from flatfile to SQL /error on date column converting

    It seems you missed step 4

    4. Double-click on the Script Component to open its editor and click on its Input Columns, search for the column containing the offending dates, and...

    Hope this helps,
    Rock from VbCity

    June 18, 2012 at 11:18 pm

    #1502577

    • Viewing 15 posts - 46 through 60 (of 128 total)