Viewing 15 posts - 706 through 720 (of 893 total)
onebite2 (12/2/2011)
1. I have some excel files in a folder(each file has different columns).
2. Files are not the same all the time.
3. I need to import files...
December 2, 2011 at 10:35 am
onebite2 (12/2/2011)
Set @sqlStr='select * into ' + @FileName + ' FROMOPENROWSET (''Microsoft.Jet.OLEDB.4.0'',''Excel 8.0;Database=C:\ExcelFiles\' + @FileName + ''', [Sheet1$])'
exec(@sqlStr)
A couple things to mention here:
1. Have you attempted to execute...
December 2, 2011 at 10:23 am
imani_technology (11/30/2011)
November 30, 2011 at 9:42 am
Fred, you will have to supply a little more information.
It isn't clear from your example whether the groups across are static or dynamic, and the same goes for the rows....
November 29, 2011 at 9:50 am
Sorry...need to rephrase.
Check the query in management studio first. Does it work there? If it does, are you pointing to the right database in your task? It seems to have...
November 23, 2011 at 11:11 am
John Mitchell-245523 (11/23/2011)
The merge-statement in T-SQL will give you the ability to compare and insert/update rows.
Although this is a SQL Server 2005 forum, so MERGE may not be an option.
John
My...
November 23, 2011 at 7:24 am
sqlfriends (11/22/2011)
I would like to do incremental import and update instead of using truncate or delete to import data from staging...
November 23, 2011 at 7:05 am
Debbie Edwards (11/23/2011)
I tried and tried but failed to get it working. I really didnt understand the script stuff onm the last post but I nearly got it sorted...
November 23, 2011 at 5:36 am
Debbie Edwards (11/22/2011)
I just ran the test and obviously it failed.
Im getting errors such as Error: The type of the value being assigned...
November 22, 2011 at 7:53 am
Debbie Edwards (11/21/2011)
Ill...
November 21, 2011 at 10:09 am
I know it is extra work, but in order to see where you are going wrong it is better to look at the actual package.
If possible, please create a small...
November 21, 2011 at 10:03 am
Could you please post your package...I cannot get to your blog from here.
November 21, 2011 at 9:57 am
That's ok...it's a little confusing at first, so let me explain in detail.
Your SQL query (in the Execute SQL Task) returns an ADO Recordset object, which can contain rows and...
November 21, 2011 at 9:16 am
You don't need a separate variable for each field in the returned resultset. It can all be contained with the same object variable, and then used in the variables mapping...
November 21, 2011 at 8:57 am
Debbie Edwards (11/21/2011)
November 21, 2011 at 8:32 am
Viewing 15 posts - 706 through 720 (of 893 total)