Hi

I couldnt understand the question properly. Could you elabrote it. Moreover by seeing the error it shows clearly that the user does not have acces. Hence login with a diferent...

Hi

You can use this beow script for creating new logins and map the permission to the respective databases.

CREATE LOGIN [<domainName>\<loginName>] FROM WINDOWS;

GO

May be useful.

Thanks

Hi

Can you try running this query through ur new query window to take backup and please check what error you are facing.

BACKUP DATABASE dbname TO DISK = N'C:\dbname.bak', DISK =...

If your question is "how to import the excel to a sql table" then

You can chose oledb source for excel and destination as oledb sql server destination and map it.

Then...

Hi All

Sorry for th elate response. I tried IBM driver but it didnt work. The doubt i have is whether DB2 uses default port and user defined port (i dont...

Hi All,

First of all for the question yes already its in DT_TimeStamp format

Thanks for the info. Actually i tried with a CAST query and it worked for me.

The query...

Hi

I tried the same but my bad its not working. It says substring does not support the data type DT_TIMESTAMP.

I tried like

(DB_DATE)(SUBSTRING(columnname, 6,4) + '-' + SUBSTRING(columnname, 4,2) +...

Thank you so much for the reply. I will work on it and will let you know the output.

If you have some other option also please let me know.

Thanks

Thanks for your reply.

This one sounds better than mine. Is there any specific function in ssis where i can change this yyyy to yy. Sorry for being so dump. I...

No. I checke dthe tables there is no codes in it. But whereas when i click the drop down from the list of tables in the sybase db from oledb...

Hi

It was my mistake. The sybase port is not the default one. It is a differnt port hence i got this issue. Now i changed the port and it worked...

i forgot to add one more point i tried importing the sybase data to sql 2005 by using dts it worked. Whereas i am not able to do the same...

Hi

I created a new odbc connection with the sybase server name and database name with port number.

Actually i am able to be establish the odbc connection without any issues. But...

Thanks Adam and greg

Thanks Greg