Viewing 15 posts - 5,611 through 5,625 (of 11,676 total)
Satheesh E.P. (7/9/2013)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 9, 2013 at 2:49 pm
Easy one, thanks for the question.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 9, 2013 at 2:45 pm
L' Eomot Inversé (7/9/2013)
Koen Verbeeck (7/9/2013)
Brandie Tarvin (7/8/2013)
Koen Verbeeck (7/6/2013)
It was closed the week we were there for maintenance...
Wait. You were there for maintenance and it was closed ... so...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 9, 2013 at 2:36 pm
Brandie Tarvin (7/8/2013)
Koen Verbeeck (7/6/2013)
It was closed the week we were there for maintenance...
Wait. You were there for maintenance and it was closed ... so you couldn't do your maintenance?
(Grammar...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 9, 2013 at 2:14 am
Steve Jones - SSC Editor (7/8/2013)
you can then go through...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 9, 2013 at 2:11 am
hvermaak (7/1/2013)
I have done the same thing since the CTP...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 8, 2013 at 6:35 am
I assume the underlying data is stored in an Excel sheet?
In SSIS, you need to specify the Excel file and the sheet to import the data.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 8, 2013 at 6:32 am
How did you create the header?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 8, 2013 at 6:30 am
This is known as the all-at-once concept in SQL Server.
This should continue to work in next versions of SQL Server.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 8, 2013 at 6:28 am
JoshuaT (7/6/2013)
I have a package that connects to a .xlsx file via the MS access driver and...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 8, 2013 at 6:20 am
Just avoid RIGHT JOIN altogether. It makes it harder to follow the logic from top to bottom. Also use brackets around your tables so you can easily see what's going...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 8, 2013 at 12:32 am
Talk about abusing Excel...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 7, 2013 at 3:45 pm
Maybe a permission issue with the SQL Agent account?
Did you use a proxy to run the SSIS job step?
You can try to log the details of the winscp command to...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 7, 2013 at 3:42 pm
Why don't you use the /config switch 2008? Or you trying to overrule configs already specified in the package?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 7, 2013 at 3:25 pm
Are we talking about package configurations?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 7, 2013 at 3:18 pm
Viewing 15 posts - 5,611 through 5,625 (of 11,676 total)