Viewing 15 posts - 5,296 through 5,310 (of 7,191 total)
If you already have a package configuration in your package, you should be able to edit it. Click on the Edit button and change the configuration type to SQL...
June 15, 2011 at 4:27 am
Before you attempt any sort of restore, you should back up the transaction log. This gives you the option to restore to any point in time. It may...
June 15, 2011 at 4:17 am
Yes, we don't say "Yours truly", but there is such a word - it means much the same as "really", as opposed to "truthfully" which means "in truth".
Anyway, annoying features....
June 15, 2011 at 2:20 am
Jim
You can use temp tables, but beware of issues with their scope and life expectancy. I think I would just create a staging table in the database. You...
June 14, 2011 at 3:51 am
Jim
You could get your data from Informix into a SQL Server staging table, and then copy from that into your main table. Then you would only need to wrap...
June 14, 2011 at 2:30 am
Not if you use a left (or right) join.
You can either import from the text file into a staging table, or you can join use the direct input from the...
June 13, 2011 at 8:27 am
Marc
I've never used a Lookup transformation, but if you look at the editor, you'll see at the top that it "enables simple equi-joins". My guess is that this means...
June 13, 2011 at 7:01 am
2. I'm still not sure what you mean. If my original reply didn't answer your question, please say what you don't understand or what further information you need.
4....
June 13, 2011 at 4:53 am
Marc
It's very difficult to visualise this. Please will you show us what the structure of your databases table(s) and text file(s) looks like?
Thanks
John
June 13, 2011 at 4:04 am
I think you need to use the PIVOT statement (or you can achieve the same with a series of CASE expressions). Have a read about that and post back...
June 13, 2011 at 3:56 am
From the sparse information you've given, a linked server or a dataflow task in SSIS seem to be what you need. Please provide more details of what you're trying...
June 13, 2011 at 3:36 am
1. I don't know. You could find out for yourself by creating a user and making it a member of both roles.
2. Not sure what you mean here....
June 13, 2011 at 3:28 am
I'm sorry, but I don't understand what you're trying to do. The statement you have posted will return just one column, but you appear to want to return at...
June 13, 2011 at 3:19 am
Well, yes - but only if such a group exists. By default, all members of the local Administrators group have full access to SQL Server (at least they did...
June 13, 2011 at 3:09 am
Speak to whoever is sysadmin on SQL server and ask them to grant it to you.
John
June 13, 2011 at 2:56 am
Viewing 15 posts - 5,296 through 5,310 (of 7,191 total)