Viewing 15 posts - 4,996 through 5,010 (of 9,715 total)
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
Google "SQL Server Editions" without the quotes plus whichever SQL Server version (2008, 2008 R2, 2012) you want to see.
December 15, 2011 at 10:04 am
Dev (12/15/2011)
Symptom of cross post:SSC refreshes the page while posting.
Workaround:
Browser's back button & hit Post. 😉
Not quite. If you don't refresh the page, you'll have the same problem....
December 15, 2011 at 9:20 am
Stefan Krzywicki (12/15/2011)
Koen Verbeeck (12/15/2011)
Back on topic again:http://www.sqlservercentral.com/Forums/Topic1222173-391-1.aspx
And it's with our personal favorite: the interview questions!
I especially like his replies. We're all fake (and not crazy?).
I do like that he...
December 15, 2011 at 9:18 am
Dev (12/15/2011)
there are at about 7 types of SQL Server DBAs in the world
Would you please share it here or give a pointer to the article.
Here's an...
December 15, 2011 at 8:05 am
Viewing 15 posts - 4,996 through 5,010 (of 9,715 total)