Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jim_jim
Constraint Violating Yak Guru
306 Posts |
 Posted - 2010-07-27 : 10:02:34
|
Iam trying to create a basic package using a data flow task.
The Task would read data from a flat file source on my computer and load the data to a SQL server 2005 database on a remote computer.
The Problem is when trying to load the data to a new table or an existing table I get the message that the selected data source is on a remote computer.The Bulk insert operation cane be executed only on the local computer.
Please help
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-07-27 : 10:17:06
|
The file has to be at a location that can be reached from your server.
The file can't be located on your client machine.
btw. Are we talking about SSIS or the old DTS?
I ask this because you have posted in forum for SQL Server 2000.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
jim_jim
Constraint Violating Yak Guru
306 Posts |
Posted - 2010-07-27 : 10:23:22
|
First thing is Iam using SSIS to create a package
Can you be more elaborate.Iam very new to SSIS
Iam able to use import/export wizard to import data from a flat file on my machine to the server.but when using the data flow task to load data drom the same flat file on my machine Iam getting the error
I only connect to the database using management studio and do not have physical access to the database server
Thanks
Vamsi |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-07-28 : 11:26:34
|
| Make sure the account used in the connection manager has permissions. Are you using windows authentication or sql authentication in the connection? |
|
|
|
jim_jim
Constraint Violating Yak Guru
306 Posts |
Posted - 2010-08-11 : 10:50:01
|
Iam using windows authentication
how to check whether my account has suitalble permissions? |
|
|
|
|
|
|
Data Flow Task issues