Viewing 15 posts - 5,746 through 5,760 (of 9,715 total)
Elliott Whitlow (6/16/2011)
To perform the moves of the files.. Did I miss something (entirely possible 🙂 )..
That's why I advised a combination of Execute SQL (to load the variables)...
June 16, 2011 at 9:07 am
Glad we could help.
Just remember, in SQL Server, there are redundant methods of accomplishing 1 task. So if you're stuck, ask for the alternatives.
June 16, 2011 at 9:06 am
Phil Parkin (6/16/2011)
Brandie Tarvin (6/16/2011)
Phil Parkin (6/15/2011)
You need SQL Server Enterprise Edition to use fuzzy lookup.
Phil, where did you get the idea that fuzzy lookup is only available to Enterprise...
June 16, 2011 at 9:02 am
sonal_anjaria (6/16/2011)
Could you elaborate a bit more about the input output wizard, i am quite new at ssis and under a tight deadline
In SSMS, open a connection to your Production...
June 16, 2011 at 8:21 am
If you have issues in the restore because of the lack of tail logs, let us know and we'll try and figure it out from there. But go ahead and...
June 16, 2011 at 8:18 am
GilaMonster (6/16/2011)
Brandie Tarvin (6/16/2011)
Try naming the Transaction. See if that gets around the error.Naming transactions does just about nothing. It's a documentation thing (with one minor exception)
I admit. That...
June 16, 2011 at 8:15 am
Elliott Whitlow (6/16/2011)
June 16, 2011 at 8:14 am
Elliott is correct on this one. Not only is SELECT...INTO going to cause you performance issues, but the use of * will also. Can I ask why you don't just...
June 16, 2011 at 8:13 am
Okay, I'm a little confused. Could you speak less in L33T / text shorthand and more in real English words, please?
How many containers do you have in your package? If...
June 16, 2011 at 8:11 am
Elliott Whitlow (6/16/2011)
Brandie Tarvin (6/16/2011)
June 16, 2011 at 8:09 am
Phil Parkin (6/15/2011)
You need SQL Server Enterprise Edition to use fuzzy lookup.
Phil, where did you get the idea that fuzzy lookup is only available to Enterprise Edition? SSIS is available...
June 16, 2011 at 8:08 am
EDIT- Whoops. Made the @@Version comment about the wrong post. My bad.
I need to see a shot of the variable from the variables window AND the entire properties box when...
June 16, 2011 at 8:04 am
Try naming the Transaction. See if that gets around the error.
Also, what you wrote makes no sense. You have a transaction with no way of backing out if there's...
June 16, 2011 at 8:01 am
sonal_anjaria (6/16/2011)
I have created two variables at the container level, not...
June 16, 2011 at 7:57 am
Sqlchicken (6/16/2011)
viduvs (6/16/2011)
I was having the same solution to install a new fresh instance and then configure the things.
Though we don't have a backup (even external backups),...
June 16, 2011 at 7:50 am
Viewing 15 posts - 5,746 through 5,760 (of 9,715 total)