Viewing 15 posts - 4,021 through 4,035 (of 11,678 total)
kapil_kk (12/19/2013)
Koen Verbeeck (12/19/2013)
kapil_kk (12/19/2013)
Koen Verbeeck (12/19/2013)
kapil_kk (12/18/2013)
I have a scenario in which I need to execute the Stored Procedure which required input parameters.
e.g. usp_TestData ?,?
I have created user...
December 19, 2013 at 3:42 am
kapil_kk (12/19/2013)
Koen Verbeeck (12/19/2013)
kapil_kk (12/18/2013)
I have a scenario in which I need to execute the Stored Procedure which required input parameters.
e.g. usp_TestData ?,?
I have created user variables in package...
December 19, 2013 at 2:34 am
mister.magoo (12/18/2013)
Also see attached sample report (works in the designer without access to any database) - click on the "Proposal" text box and look at the "Format" property.
Nice touch 😉
December 19, 2013 at 1:06 am
kapil_kk (12/18/2013)
I have a scenario in which I need to execute the Stored Procedure which required input parameters.
e.g. usp_TestData ?,?
I have created user variables in package itself and done...
December 19, 2013 at 12:59 am
Phil Parkin (12/19/2013)
chaseurpuli (12/18/2013)
Phil Parkin (12/18/2013)
Phil Parkin (12/18/2013)
Sounds like you need an asynchronous script component.But why do you care what the column name is?
Thanks for your reply Phil. Unfortunately, the...
December 19, 2013 at 12:19 am
wendy elizabeth (12/18/2013)
can you tell me what A4 portrait means? is this letter size paper? If there are different paper sizes, can you tell me what they are?
Portrait is the...
December 18, 2013 at 1:03 pm
In that cause you just need to make sure there is data for every cell.
Do OUTER JOINS between tables and replace NULL with empty strings.
December 18, 2013 at 1:01 pm
Open up the script component, build it, save it and then redeploy the package.
December 18, 2013 at 6:12 am
rajnidas.y (12/18/2013)
it was working in local machine but not in live production server .thanks
So, two different machines after all.
And no special assemblies used?
Does the server has the same .NET...
December 18, 2013 at 5:43 am
kapil_kk (12/18/2013)
Koen Verbeeck (12/18/2013)
kapil_kk (12/18/2013)
After data gets transferred change the status flag to 1 for those rows...
In which table? Table1 or table2?
in table1 from which I am transferring data..
Now it's...
December 18, 2013 at 5:28 am
kapil_kk (12/18/2013)
After data gets transferred change the status flag to 1 for those rows...
In which table? Table1 or table2?
December 18, 2013 at 5:22 am
Abu Dina (12/18/2013)
kapil kapil kapil..... what's wrong bro? 😛
You're transferring all records where StatusFlag = 0 so your UPDATE statement will be changing all records with StatusFlag = 0 to...
December 18, 2013 at 5:14 am
kapil_kk (12/18/2013)
Abu Dina (12/18/2013)
I like to keep things simple so I would link the Data Flow Task to an Execute SQL Task (with On Success precedence constraint)...
December 18, 2013 at 5:09 am
rajnidas.y (12/18/2013)
running project at same machine but live project machine.
Care to explain a bit more?
December 18, 2013 at 5:06 am
Viewing 15 posts - 4,021 through 4,035 (of 11,678 total)