Viewing 15 posts - 1,021 through 1,035 (of 3,666 total)
Use a script task in your control flow to get that information from the file name and store it in a variable. You can then use that variable in...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
July 21, 2014 at 11:15 am
I would have to see the file format before even thinking about options.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
July 17, 2014 at 9:04 am
Instead of removing the identity specs, take a look at: SET IDENTITY_INSERT tablename OFF
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 28, 2014 at 10:03 am
Are the other select statements doing anything other than just returning values? If not then I can't see why they are needed.
I'm having trouble picturing why statements that are returning...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 28, 2014 at 9:08 am
Luis Cazares (5/27/2014)
Something like this:
DECLARE @CSV ...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 28, 2014 at 7:32 am
ChrisM@Work (5/28/2014)
Alvin Ramard (5/28/2014)
Luis Cazares (5/27/2014)
The code makes clear that there's a concatenation based on multiple values on a single column.
CASE WHEN A.[COL_1] LIKE '%cricket%' THEN 'ck' + ','...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 28, 2014 at 7:29 am
Luis Cazares (5/27/2014)
The code makes clear that there's a concatenation based on multiple values on a single column.
CASE WHEN A.[COL_1] LIKE '%cricket%' THEN 'ck' + ',' ELSE '' END...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 28, 2014 at 7:14 am
Luis Cazares (5/27/2014)
I agree, a redesign to normalize the tables should help you solve this and other issues.
Excuse me Luis, but where did you get the idea that a redesign...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 27, 2014 at 3:45 pm
Brad,
You do not have to recreate anything. You can edit each data flow, including the associated connections, to add the required column.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 27, 2014 at 3:17 pm
Steve Jones - SSC Editor (5/19/2014)
David Burrows (5/19/2014)
SQLRNNR (5/19/2014)
Better yet, what if people just started throwing in a couple hundred pages of fiction (story form) into their SQL books?
As in...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 19, 2014 at 8:35 am
The above version seems to work.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
January 22, 2014 at 11:36 am
The last script posted shows the Primary_Key_Ind = Yes for every column in my database.
That's definitely not correct!
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
January 22, 2014 at 9:52 am
You're welcome and Happy New Year to you too.
Let us know if you have any more issues.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
December 30, 2013 at 12:21 pm
Your problem is that you have not restricted the times as you wanted to.
You're asking for values between 12/15/2013 17:00:00 and 12/21/2013 08:00:00 not between 12/15/2013 and 12/21/2013 only where...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
December 30, 2013 at 12:18 pm
It would be helpful if you told us what issues you're experiencing.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
December 30, 2013 at 12:03 pm
Viewing 15 posts - 1,021 through 1,035 (of 3,666 total)