November 28, 2011 at 12:09 pm
I am using sql server 2005 BIDS. I want to use one SSIS package which get the data from source database Sybase executing one sql statement (select * from tblsource where id=@ID) and load all data into sql server 2005 database.
There is one sql.ini file which we uses to define data server. For the syabase connection i need to define the connection manager,sql. ini file location,interface file server name,database name...please help me how i can achieve this?
It will be helpful if i get the step by step help as i am new to SSIS.
November 28, 2011 at 10:26 pm
Want to clarify datasource is Sybase ASE ODBC Driver.. i need to connect this datasource using SSIS.
November 30, 2011 at 2:42 am
First things first. have you created a connection manager that successfully connects to your server?
This might help you along:
You need to make sure that the Sybase client is installed on your dev machine then you should see the Sybase OLE DB driver. If not you may need to create an System ODBC connection to Sybase then use the SSIS ODBC driver to connect to that.
What does this mean:
"For the syabase connection i need to define the connection manager,sql. ini file location,interface file server name,database name"
Is this something you actually need to do is this just trying to make your initial connection to Sybase?
November 30, 2011 at 11:17 pm
Thanks Nick for reply. The sql.ini file details helped me to create Sybase oledb connection.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply