April 30, 2009 at 4:15 am
I have a client of SQL Server 2005 with BIDS. I created a package with the Bulk Insert Task.
In that, I have taken a flat file as source and sql server as destination.
then i executed the package.
the package execution is getting failed.
kindly suggest me in this regard
Thanks
Sathish
April 30, 2009 at 5:03 am
Can you post the errors that you get while executing the package?
--Ramesh
April 30, 2009 at 12:20 pm
I have removed the attachment as it seemed to contain a number of items that were inappropriate.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
May 4, 2009 at 5:19 pm
Satish,
Verify if you configured the text file source properly. And also check for the source to target mappings as well. SSIS pretty much does everything if you configure the source and target mappings correctly.
🙂
May 6, 2009 at 1:27 am
Hi,
I mapped all the columns properly from Flat file source to SQL server destingation.
when i execute the same package in the server, it is executing successfully. but the same is not happening in the client.
kindly suggest me....
Thanks
Sathish Banda
May 6, 2009 at 2:41 am
Bit difficult without logs, but sounds like permissions?
Is the connection for SQL Server using windows authentication?
Are you executing the package client side with the same privileges as when you log onto the server to execute?
If permitted to, create a SQL Server logon with the correct permissions and change the connection to use that to see if this resolves the issue, then take it from there.
cheers, Jode
May 6, 2009 at 5:15 am
Are you using a 'SQL Server Destination' in your dataflow? SQL Server Destination only works at the server-side. If your package has to connect to a remote server, use the 'OLE DB Destination' instead.
Peter
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply