Viewing 15 posts - 4,981 through 4,995 (of 9,707 total)
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
And are you sure no changes, like password changes, were made to the service account?
December 15, 2011 at 10:10 am
I forgot to add... Have you looked at using Service Broker for your needs?
December 15, 2011 at 10:09 am
Why would you put your CLUSTERED index on the ID field of the table? You're not searching by ID, presumably, but by date or another field. You can do a...
December 15, 2011 at 10:08 am
Viewing 15 posts - 4,981 through 4,995 (of 9,707 total)