Viewing 15 posts - 61 through 75 (of 101 total)
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.
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
May 7, 2010 at 7:50 am
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...
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
May 7, 2010 at 1:07 am
Really nice script buddy.. Thanks for the post..
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
May 6, 2010 at 11:35 pm
If you hard code the parameter values, does the query work OK?
If I hard code the two parameter values then the task is working fine.
Are you certain that...
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
May 6, 2010 at 8:09 am
Try this EXEC BIW_Status ?, ? and map the parameters correctly
Tried with EXEC BIW_Status, but got same error.
What is the issue with parameters..? I really don't know. Can you...
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
May 6, 2010 at 7:29 am
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,...
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
May 6, 2010 at 6:48 am
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....
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
May 5, 2010 at 8:56 am
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=" +...
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
May 5, 2010 at 5:01 am
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...
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
May 5, 2010 at 1:08 am
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,...
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
May 5, 2010 at 12:56 am
Good Question to analysis..
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
May 5, 2010 at 12:39 am
Hi,
Are you using a 64-bit machine by any chance?
No, I'm not using 64-bit machine. It is 32-bit machine.
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
May 5, 2010 at 12:23 am
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...
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
May 5, 2010 at 12:17 am
Hi,
I enabled configuration options in Surface Area Configuration and tried but not succeed.
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
May 4, 2010 at 11:54 pm
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...
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
May 3, 2010 at 8:15 am
Viewing 15 posts - 61 through 75 (of 101 total)