Claudia
3/22/2007 8:57:00 PM
This is my original OPEN ROWSET into temp database (works good):
SELECT MyDerivedTable.*
INTO tempdb.dbo.MyTable
FROM OPENROWSET('MSDASQL', 'Driver={Microsoft Text Driver (*.txt;
*.csv)}; DefaultDir=C:\company folders\CorporateUpload;',
'select * from ContactList.csv') AS MyDerivedTable;
---- The logic stops at the last global statment (the OPENROWSET) -- should
I have a QUOTENAME for anything else here? Text rendered seems exact when
rendered.
DECLARE
@schemaname AS NVARCHAR(128),
@dbname as nvarchar(128),
@tablename AS NVARCHAR(128),
@DROPIT AS NVARCHAR(4000),
@WRITEIT AS NVARCHAR(4000);
SET @schemaname = N'dbo';
SET @dbname = N'tempdb';
SET @tablename = N'MyTable';
SET @DROPIT = N'DROP TABLE '
+ QUOTENAME(@dbname) + N'.'
+ QUOTENAME(@schemaname) + N'.'
+ QUOTENAME(@tablename) + N';'
/*
EXEC(@DROPIT);
*/
IF OBJECT_ID(QUOTENAME(@tablename))IS NOT NULL
EXEC @DROPIT;
SET @WRITEIT = N'SELECT MyDerivedTable.* INTO '
+ QUOTENAME(@dbname) + N'.'
+ QUOTENAME(@schemaname) + N'.'
+ QUOTENAME(@tablename) + N''
+ 'FROM OPENROWSET(' + '''' + 'MSDASQL' +''''+ ', ' + '''' +
'Driver={Microsoft Text Driver (*.txt; *.csv)}; DefaultDir=C:\company
folders\CorporateUpload;' + '''' + ',' + '''' + ' select * from
ContactList.csv' + '''' + ') AS MyDerivedTable;'
---
note:
Other item needed: A COMMA DELIMITED FILE IS LOCATED IN C:\company
folders\CorporateUpload