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 packageCan you be more elaborate.Iam very new to SSISIam 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 errorI only connect to the database using management studio and do not have physical access to the database serverThanksVamsi |
|
|
|
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 authenticationhow to check whether my account has suitalble permissions? |
|
|
|
|
|
|
Data Flow Task issues