BULK INSERT AND Flat FIle
-
This question might not directly relate to SSIS, however i am gonna post here becoz i came across it during package bulding and many of us had done this in SSIS.
Scnerio: I am using Client Utility tool to connect to SQL. I have a SSIS package ( build in my local machine, in my PC) that do a bulk insert into sql server ( this is another box)
We know its trying to find flat file in the server where its doing bulk insert. But i can Give UNC path for my flat file since my flat file is in my local machine.
Now problem. I tried several combinations of UNC to open that flat file. i cannot.
Here is the IP address of my local machine 11.111.111.111
my drive C:\
folder name loading.txt
Now i tried to open this file through RUN--\\11.111.111.111\C$\Loading.txt---------i cannot open either.
What are the things i am doing wrong here? I read few articles about UNC , SP2, firewall, but still couldnot figure it out.
Thanks
-
the issue is permissions, i'm pretty sure.
it doesn't matter which user you are logging into SQL server, whether domain admin,sa, or anyone else.
it's when you try to access services or share OUTSIDE of the database, a specific account unrelated to your login is used for that.
the issue is the NETWORK permissions of the accoutn that is running the SQL Server Service:
it's probably SYSTEM, but SYSTEM never logs into a domain, and thus establises whether it has access to \\anymachine\C$
ON THE SERVER, I believe if you go to Control Panel>>Administrative tools>> Services
open up your SQL Server and go to this screen, you'll see what I mean.
You'll want to create or change that to a user who can login to the domain and browse to the shares you are looking for:
gyanendra.khadka (8/4/2008)
This question might not directly relate to SSIS, however i am gonna post here becoz i came across it during package bulding and many of us had done this in SSIS.Scnerio: I am using Client Utility tool to connect to SQL. I have a SSIS package ( build in my local machine, in my PC) that do a bulk insert into sql server ( this is another box)
We know its trying to find flat file in the server where its doing bulk insert. But i can Give UNC path for my flat file since my flat file is in my local machine.
Now problem. I tried several combinations of UNC to open that flat file. i cannot.
Here is the IP address of my local machine 11.111.111.111
my drive C:folder name loading.txt
Now i tried to open this file through RUN--\\11.111.111.111\C$\Loading.txt---------i cannot open either.
What are the things i am doing wrong here? I read few articles about UNC , SP2, firewall, but still couldnot figure it out.
Thanks
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
Thanks, I did.
I think we are not on the same page here. ( I belive, I fail to explain here enough).
I don't have SQL Server on my machine( my Local Lan Box). I am using just client utility to connect to sql server.
It can be true that this issue is related to permission.
When i got to RUN in my local machine and type different server name it prompts me to enter credentials. ok, lets say this is-- "22.222.222.22" is the ip address or server name where the sql server is
so i go to RUN and type --\\22.222.222.22\C$ and hit enter, it askes for me to enter the user name and password.
Now, 11.111.111.11 is the ip address of my local machine and where i have the ssis packages.
When i got RUN and type \\11.111.111.11\C$ this doesn't work, says no provider accepted the given newtwok path.
what i my trying to do is give the UNC path in my flat file connection for my ssis packages. so \\11.111.111.11\C\loading.txt can be open. SInce i cannot open this file through RUN in my local machine, it doen't work.
Thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply