Viewing 15 posts - 11,866 through 11,880 (of 13,401 total)
Sounds like an automated backup/restore process might be more efficient - are you effectively just replacing the dev db?
January 19, 2010 at 10:24 am
Are the files all of the same format? Are they going to the same destination folder?
January 19, 2010 at 12:19 am
Another alternative, of course, is to do it all in one hit at the end, using a simple UPDATE query.
January 18, 2010 at 3:05 pm
You almost answered your own question. Create a lookup table in SQL Server and then use the Lookup transformation in your dataflow.
January 18, 2010 at 10:50 am
Is this an SSIS question?
January 15, 2010 at 10:57 am
Oops, sorry. Glad you got it in the end.
January 15, 2010 at 9:06 am
Is DateStamp a column name in emDetail?
If so, your syntax is going to be more like this:
update dbo.emDetail
set dateYear = DATEPART('year',datestamp)
Remember single quotes for literals in T-SQL.
January 15, 2010 at 8:46 am
To update existing data, you need to use an OLEDB Command transformation. The various different Destination components are for INSERTs only.
January 15, 2010 at 7:19 am
Other than "can someone help me", there is no question in your post, it's just a statement about what you're doing.
January 15, 2010 at 7:16 am
I think I may have misunderstood your requirement. Are you trying to UPDATE records which are already on the database, rather than doing an INSERT?
January 15, 2010 at 7:06 am
You say 'thanks in advance', but all you've done is told us what you are trying to do, without asking for anything. Which part, specifically, would you like help with?
January 15, 2010 at 1:19 am
If you double click on your destination in your dataflow and select Mappings, you should see the new derived column as an available input column - just change the mapping...
January 15, 2010 at 1:12 am
I'd be tempted to heed the error message and give the column a name:
SELECT '00' + CONVERT(VARCHAR(8),GETDATE(),112)+
' WEEKLY DATA FEED'+
REPLICATE(' ', 190) Col1
--etc etc
January 15, 2010 at 1:03 am
The word 'here' in my previous post is a hyperlink.
January 14, 2010 at 9:18 am
Good old Excel. First place to start might be with IMEX=1 in your connection string. See here for more info.
January 14, 2010 at 6:59 am
Viewing 15 posts - 11,866 through 11,880 (of 13,401 total)