Buddies,

I am using SS2005 and I ran the first query: DECLARE @TimeStart DATETIME

DECLARE @Time DATETIME

DECLARE @TimeEnd DATETIME

DECLARE @I INT

DECLARE @Count INT

SET @I = 0

SET @Count = 0

SET @TimeStart = GETDATE()

SET...

You both suggested me very good. Thanks for your help. Actually I am new to SSIS. I don't know much, learning one by one. Kindly don't misunderstand.

yep, got it..!

Finally I removed mapping in parameter mapping tab of my execute sql task package and used expressions to get it.

Created total three variables.

One for stored procedure, second for...

Really nice script buddy.. Thanks for the post..

If I hard code the two parameter values then the task is working fine.

Are you certain that...

Tried with EXEC BIW_Status, but got same error.

What is the issue with parameters..? I really don't know. Can you...

Please find attached screen shots.

Still I am getting error:

[p][Execute SQL Task] Error: Executing the query "BIW_Status" failed with the following error: "The OdbcParameterCollection only accepts non-null OdbcParameter type objects,...

Thanks for your replies but my query is actually I'm using Sql Server 2005's BIDS to create SSIS package. then why it gives a .dtsx file instead of .dts file....

Finally I've got it.

these lines I've added to my code:

Imports Microsoft.Data.Odbc

Dim conn As Odbc.OdbcConnection

Dim comm As Odbc.OdbcCommand

Dim conn As Odbc.OdbcConnection

Dim comm As Odbc.OdbcCommand

connectionString = "DSN=BI_Database;UID=" + Login + ";Pwd=" +...

Yeah, I have tried it but not succeed. Here is the connection string:

SQLCon.ConnectionString = "Data Source=Source;Initial Catalog=BIW;User ID=" + Login + ";Password=" + Password + ";Trusted_Connection=True;"

Login and Password are variables...

Hi Phil Pakin,

You are right.

Initially I created a data source under Data Sources folder in Solution Explorer that is using System DSN.

Next I created a connection in Connection Managers,...

Good Question to analysis..

Hi,

No, I'm not using 64-bit machine. It is 32-bit machine.

Hi,

In my existing DTS 2000 packages has ActiveX Script Task. I heard like the ActiveX Script task may be deprecated in a future release of SQL Server. So I need...

Hi,

I enabled configuration options in Surface Area Configuration and tried but not succeed.