Hi divyanth,

I have created .Net Providers\ODBC Data Provider connection and tried but got failed.

Actually I'm migrating existing DTS packages to SSIS packages. In these existing DTS packages they have...

Hi Sharath,

Thank you. I have tried with your code.

cn.Open "DSN=BI_Database;UID=" & DTSGlobalVariables("gstrTargetLogin").Value & ";PWD=" & DTSGlobalVariables("gstrTargetPassword").Value

Here "BI_Database" is data source. I'm able to open connection successfully when I use...

Hi Sharath,

Thanks for your response. Yes I want to use Script Task. Can you provide me sample code.

Hi,

Thanks for your response. I have changed connection from ODBC to ADO.NET. Now it started working.

Interesting..:w00t:

Hi,

check your data sources and linked servers once.

KSB.

If I executeEXEC xp_cmdshell 'dir *.exe';

GO it is working fine.

And if I execute BCP job I'm getting error.

Thanks for reply

This link might assist you: http://www.dbnewsgroups.net/group/microsoft.public.sqlserver.programming/topic16744.aspx%5B/quote%5D

I have tried this too..

EXEC sp_configure 'show advanced options', 1

GO

RECONFIGURE

GO

EXEC sp_configure 'xp_cmdshell', 1

GO

RECONFIGURE

GO

exec sp_xp_cmdshell_proxy_account 'domain\user', 'password'

Still getting same error.

Thanks,

KSB

Thanks for reply.

Executed fine but same results. Getting the following error [p]Error string: [Microsoft][ODBC SQL Server Driver][SQL Server]The EXECUTE permission was denied...

Hi,

Maximum length for stored procedures and functions name is 128.

Always choose name as meaningful and as much as short.

Thanks,

KSB.

Hi,

You can use PIVOT. Check this link:

http://msdn.microsoft.com/en-us/library/ms177410.aspx

KSB.

Hi,

Keep the same in color property and change text box Expression as

IIf(Fields!DocNumbr.Value)=NULL,"Invoice Not Raised",Fields!DocNumbr.Value)

KSB.

Hi,

Check whether your servers are linked in Server Objects -> Linked Servers

and also verify protocols TCP/IP and Named Pipes are enabled or not.

KSB.

Hi Lowell,

Thanks for the resolution.

Hi Lowell,

Thanks for quick reply and it is working fine for decimal.

What about for float..?

Thanks.