Viewing 15 posts - 9,856 through 9,870 (of 13,874 total)
Nimesh_Parikh (5/31/2013)
I know I am asking very silly question, But We have put all our efforts to develop SSIS 2012 solution and now customer requirement changes and they wants to...
May 31, 2013 at 9:17 am
.. use indent, otherwise code looks like noodles.
:hehe:
May 31, 2013 at 12:56 am
Conditional Split is the task you need. Add it after the derived column from the previous post. Send all NULLs to one output and everything else to the other. Then...
May 30, 2013 at 6:17 am
Great, thanks for posting back.
May 30, 2013 at 2:06 am
Nomvula (5/30/2013)
i have excel souce with data that i need to import into oledb destination, here's an example of my the import
INVOICE DESCRIPTIONPOSTING DATE
Posted ...
May 30, 2013 at 1:42 am
Maybe try something like
Isnull([Month 01]) && Isnull([Month 02]) etc
May 30, 2013 at 1:09 am
Also, for future info, I've reformatted this (thanks Redgate, but there are free alternatives) and put it in tags. See how much easier it is to read:
select count(tvid)
...
May 29, 2013 at 9:13 am
Bhaskar.Shetty (5/29/2013)
Try this...
SELECT CASE WHEN StartDate IS NULL THEN 'N/A' ELSE CAST(DATEDIFF(dd,StartDate,EndDate) AS varchar) END Days
Using your code, adapted slightly:
declare @StartDate date = '20130501'
--Wednesday
declare @EndDate date = '20130507'
...
May 29, 2013 at 8:58 am
var05 (5/29/2013)
The problem is both the tables dont reside...
May 29, 2013 at 7:50 am
var05 (5/29/2013)
Say I have a table in SQL where in I add and remove the employee names.
My Execute sql task will pick up the employees in that ABC sql...
May 29, 2013 at 7:21 am
var05 (5/29/2013)
I would like to know how to pass a paramater from Execute SQL task to OLE DB source
I have an execute sql task returing a full result query....
May 29, 2013 at 6:30 am
Where to begin troubleshooting?
Put both result sets in database tables and run some queries so that you can understand what the extra rows look like. Then, maybe, you can...
May 29, 2013 at 12:52 am
KoldCoffee (5/28/2013)
May 28, 2013 at 11:50 pm
Viewing 15 posts - 9,856 through 9,870 (of 13,874 total)