January 30, 2014 at 10:27 am
Hello,
I am working on a project where I need to retrieve the contents of an MS Access table using SSIS that is on a remote server.
Info.
To access the Access DB I have to use remote desktop
The access DB is on that remote server
I'd like to build a connection in SSIS to bring the contents of the table to SQL Server to build a report.
Any ideas?
Thanks
January 30, 2014 at 10:40 am
mbrady5 (1/30/2014)
Hello,I am working on a project where I need to retrieve the contents of an MS Access table using SSIS that is on a remote server.
Info.
To access the Access DB I have to use remote desktop
The access DB is on that remote server
I'd like to build a connection in SSIS to bring the contents of the table to SQL Server to build a report.
Any ideas?
Thanks
You can't create a connection string through RDP. Your sql box MUST be able to see the location where your Access file is located. Remember that all that is really happening is that sql is going to open that file.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
January 30, 2014 at 10:43 am
Sean, thanks for the (as usual) fast and helpful response. I will need to think of some other creative ways to grab that data. Thanks again.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply