Viewing 15 posts - 4,021 through 4,035 (of 11,676 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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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 😉
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 19, 2013 at 12:19 am
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 19, 2013 at 12:17 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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 18, 2013 at 1:01 pm
Open up the script component, build it, save it and then redeploy the package.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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)...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 18, 2013 at 5:06 am
Viewing 15 posts - 4,021 through 4,035 (of 11,676 total)