Please follow Steps, u can get yesterday DATE: in Execute SQL task: DECLARE @pdtBUSINESS_DATE SMALLDATETIME SET @pdtBUSINESS_DATE=DATEADD(day,-1,GETDATE()) EXEC MISETLEXTDATA @pdtBUSINESS_DATE , 0 , '02-01-03' , 'DAILY'...

i want run this procedure in SSIS, so am running thru Execute task. EXEC MIS_ETL_EXT_DATA '20120520' , 0 , '02-01-03' , 'DAILY' here 20120519 is YYYYMMDD (yesterday date) 0 - static value 02-01-03 - Procedure ID Daily - Frequency this job is Schedule...

i want run this procedure in SSIS, so am running thru Execute task. EXEC MIS_ETL_EXT_DATA '20120520' , 0 , '02-01-03' , 'DAILY' *here 20120519 is YYYYMMDD (yesterday date) 0 - static value 02-01-03 - Procedure ID Daily - Frequency* this job is Sche...

I got solution, i used Sybase SQL Anywhere OLDB Provider 11 and destination also OLDB Provider. http://www.sybase.com/detail?id=1085077&id=1085077...

Hi, I am trying to load data from falt file source to Sybase IQ 15.1 destination using SSIS 2008. I am using ADO.NET destination component with Sybase IQ ODBC data provider to connect to the Sybase IQ db. Though the package is able to load the data, pe...

Hi, I am trying to load data from falt file source to Sybase IQ 15.1 destination using SSIS 2008. I am using ADO.NET destination component with Sybase IQ ODBC data provider to connect to the Sybase IQ db. Though the package is able to load the data, per...

We wish to use these pages for publishing various documents, announcements, FAQ etc related to beyondrelational.com...

Very good work Sudeep....

Hi Mitesh, am getting this error, Domain error during implicit conversion of NUMERIC value '' to a NUMERIC field. Source: Flat files Target: sybase...

Domain error during implicit conversion of NUMERIC value '' to a NUMERIC field. Source: Flat files, Target : Sybase ...