Viewing 15 posts - 4,996 through 5,010 (of 9,712 total)
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
Back on topic...
sqldba2k8, if you want to learn SQL Server, grab Books Online, grab a How-To book (I used Sybex Certification books back in the day), get yourself a cheap...
December 15, 2011 at 7:38 am
That is good information, Jon. Thanks for the link!
EDIT: Although, this issue probably is something that needs reported to Microsoft to see if they'll fix it.
December 15, 2011 at 7:29 am
Personally, I like to grab chocolate when things break. It makes life so much more pleasant to eat chocolate while the world is falling apart around me. @=)
December 15, 2011 at 6:47 am
Viewing 15 posts - 4,996 through 5,010 (of 9,712 total)