Viewing 15 posts - 4,996 through 5,010 (of 9,722 total)
GilaMonster (12/19/2011)
http://www.simple-talk.com/opinion/geek-of-the-week/gail-shaw-geek-of-the-week/
And because she posted, I have to post it to, darnit.
I deserve to be a LOLMVP too! And an ETCMVP, and a ROFTLOLMVP, and every other type of ......
December 19, 2011 at 10:31 am
OMG, we have a shark on the group! Lutz has been eaten by a shark!
(Eat both squares, please)....
[/weirdmood]
Yes, it has been one of those mornings.
December 19, 2011 at 8:03 am
jcrawf02 (12/16/2011)
December 16, 2011 at 7:58 am
Ai haz HTML airorz codz:
http://icanhascheezburger.com/2011/12/15/funny-pictures-http-status-cats/%5B/url%5D
EDIT: Whoops. Linx Fixt
December 16, 2011 at 5:13 am
ALZDBA (12/15/2011)
Jeff Moden (12/15/2011)
Brandie Tarvin (12/15/2011)
Why would you put your CLUSTERED index on the ID field of the table?To prevent page splits on a massive table.
My bet - and this...
December 16, 2011 at 5:10 am
Then my answer is no. You have to use (and update) some sort of configuration setting (XML, Table Config, etc.) for the package in order to get this to work.
If...
December 16, 2011 at 5:08 am
Sapen (12/15/2011)
December 15, 2011 at 12:48 pm
I know this probably has nothing to do with the issue, but I'm going to ask you to check anyway.
Verify all your hard drives have free space (and a decent...
December 15, 2011 at 12:10 pm
Okay, the Parameters box of the OLE DB Source has Parameters and Variables. Parameter0 should map to the variable that is the first date and Parameter1 should map to the...
December 15, 2011 at 12:05 pm
Sapen (12/15/2011)
What ParameterNames are you using for the variables?
fromtimestamp, totimestamp they are of type datetime.
That's your problem. The Execute SQL task doesn't allow actual string names to be used...
December 15, 2011 at 12:01 pm
Guras (12/15/2011)
"C:\\" + @[User::i_fileFormatList] + ".csv"I receive the following error when I click the evaluate expression button
The dat type of variable User::i_fileFormatList is not supported as an expression
It...
December 15, 2011 at 11:52 am
Post the expression, the value of the variable at that time (to your best guess) and the exact error message you are receiving.
December 15, 2011 at 10:21 am
What ParameterNames are you using for the variables?
December 15, 2011 at 10:17 am
Guras (12/15/2011)
TedT (12/15/2011)
Try this:http://www.sqlis.com/sqlis/post/Looping-over-files-with-the-Foreach-Loop.aspx
4. Use the variable as a parameter in your data flow task
Give it a shot, and let me know of any specific queries/challenges you come across.
Thank you!...
December 15, 2011 at 10:15 am
Viewing 15 posts - 4,996 through 5,010 (of 9,722 total)