|
|
-
Anil Question Received 1 Days ago through ASK
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...
|
ask
92
·
2% ·
491
|
|
-
Nirav Gandhi Question Received 12 Days ago through ASK
I want to migrate Database from Sql Server 2005 to 2008.Please give me idea about this.
How can Copy Role and User Name ?
I have planned Following Step for migration because Copy database not supported.
1) Backup Database or (detach and attach met...
|
|
ask
92
·
2% ·
491
|
|
-
Anil Question Received 14 Days ago through ASK
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...
|
|
ask
92
·
2% ·
491
|
|
-
Sana ali Question Received 17 Days ago through ASK
Hi All,
Could you all please help with this urgent need of creating a package where I have to import data from Multiple sheets of an excel file and load it into one table.
I have total 9 sheets on an Excel file with all different Metadata..Its like fi...
|
|
ask
92
·
2% ·
491
|
|
-
Maxim Question Received 17 Days ago through ASK
Why in level = 3 we have 1-1-2-2 rather than 1-2-3-4? And how can i get for level = 3 result like 1-2-3-4?
<pre>
if OBJECT_ID('tempdb.dbo.#lt') is not null
drop table #lt
create table #lt (p int, c int)
insert into #lt
values
(1,0),
(2,1),
...
|
|
ask
92
·
2% ·
491
|
|
-
Pradeep Question Received 18 Days ago through ASK
<Table Border=1>
<th>LoanID</th>
<th>TaskID</th>
<th>LoanStatus</th>
<th>TaskStatus</th>
<th>Task Created Date</th>
<th>Task Modified Date</th>
<th>Loan Status Created Date</th>
<th>Loan Status Modified Date</th>
<th>Assinged to</th>
<th>Loan Pro...
|
|
ask
92
·
2% ·
491
|
|
-
Anil Question Received 20 Days ago through ASK
Hi,
am new to SSIS, please provide steps for to generate Sequence Generator(RowID) thru Derived column in ssis...
|
|
ask
92
·
2% ·
491
|
|
-
Anil Question Received 20 Days ago through ASK
I got this problem My source : Flat files, Target : Sybase and datatype is Numeric(20,3)
this expression not working in SSIS
[ASEOLEDB]*((dt_numeric,20,3)SUBSTRING(STRING,44,11)) / 1000*[ASEOLEDB] when am running SSIS job, am getting this error: [ADO N...
|
|
ask
92
·
2% ·
491
|
|
-
Anil Question Received 21 Days ago through ASK
Dear,
please convert into SSIS
REPLICATE('0',16-len(CONVERT(VARCHAR,@TERMINAL_ID))) + CONVERT(VARCHAR,@TERMINAL_ID)
my input: 12345
Expected Output: 0000000000012345...
|
|
ask
92
·
2% ·
491
|
|
-
Shivendra Kumar Yadav Question Received 24 Days ago through ASK
Is it Possible to save data in chinese and fetch date in English ?...
|
|
ask
92
·
2% ·
491
|
|