Post reply

Variables in Flat file Connection?

  • January 6, 2012 at 2:07 am

    #146790

    Hi Friends,

    I have a variable which stores a path on my local machine....

    source and destination is a flat file connection....i have to put the variable in the destination..i mean the path which has the file to store the data in the local drive....i have no problem with this...

    but when i try to open another server its not working..i put like \\192.168.14.25\d$...

    is this possible to open another server's path like this and getting the destination file...? or any other option to do this?

    Help me friends

    Thanks,
    Charmer

  • January 6, 2012 at 2:25 pm

    #1429881

    Is creating a mapped drive an option in your environment ?

    Brian Kukowski

  • January 10, 2012 at 2:38 am

    #1430948

    Brian Kukowski (1/6/2012)

    Is creating a mapped drive an option in your environment ?

    no its a different server..

    Thanks,
    Charmer

  • January 10, 2012 at 5:31 am

    #1431025

    So what's the error message? is it a permission issue or can't find the path?

    I'm not sure if you can connect using the '$' sign to a hidden share, but YES of course you can connect to any remote server since you have the right permissions.

  • January 10, 2012 at 6:11 am

    #1431049

    JasonYousef (1/10/2012)

    So what's the error message? is it a permission issue or can't find the path?

    I'm not sure if you can connect using the '$' sign to a hidden share, but YES of course you can connect to any remote server since you have the right permissions.

    it says invalid path

    Thanks,
    Charmer

  • January 10, 2012 at 7:24 am

    #1431137

    Don't think this is SSIS. Certainly sounds like permissions to me.

    When you see this error are you running the package in bids from your own machine or using SQL Server Agent?

  • January 10, 2012 at 7:35 am

    #1431151

    aaa-322853 (1/10/2012)

    Don't think this is SSIS. Certainly sounds like permissions to me.

    When you see this error are you running the package in bids from your own machine or using SQL Server Agent?

    from local machine

    Thanks,
    Charmer

  • January 10, 2012 at 7:39 am

    #1431156

    What output you get when you type in following in Windows explorer?

    \\192.168.14.25\d$

    If it errors out, it’s a permission issue.

  • January 10, 2012 at 8:18 pm

    #1431539

    Is \\192.168.14.25\d$ the exact value you're typing in for the expression? If so, I think the issue is that the backslash in SSIS is used as the escape indicator. You need to use a double backslash to implement a single backslash. So, the way to specify the path would be

    \\\\192.168.14.25\\d$

    See the following for more info

    http://sqlblog.com/blogs/andy_leonard/archive/2009/01/30/an-introduction-to-the-ssis-expression-language.aspx

    http://msdn.microsoft.com/en-us/library/ms141001.aspx

    Brian Kukowski

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply