Hello hope it's not o late...

I'm looking for the same problem and found:

http://dba.stackexchange.com/questions/15619/table-of-constants-is-this-common-practice

and here..

http://www.sqlservercentral.com/Forums/Topic411110-403-1.aspx

I got it!

Thanks to your link Steven!

It was a problem of correct ordering...

I got it to work like this:

SELECT

TAG,

Parent,

[Type!1!Type],

[Type!1!TypeID],

[Type!1!TypeName],

[Type!1!TypeValue],

[Property!2!Type],

[Property!2!PropID],

[Property!2!PropName],

[Value!3!Type],

[Value!3!ValID],

[Value!3!ValName],

[Value!3!ValValue]

FROM

(

-- get all Types from TBL!Value!Types

SELECT

1 AS TAG,

NULL AS Parent,

'Type' AS...

Hello Steven,

yesterday I was running a Little bit out of time... sorry...

But here are the scrits to generate the tables:

the first:

USE [ID1167_LS]

GO

/****** Object: Table [dbo].[TBL_Value_Types] Script...

Hello all!

I've solved my problem. 🙂 For all who are interested:

I use the following schema.ini:

[BackupScheduler.txt]

Format=FixedLength

ColNameHeader=False

Col1=Text_To_Exec LONGCHAR Width 8000

My statement to execute is:

INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Text; Database=C:\zw\; HDR=No;', [BackupScheduler#txt])

SELECT REPLICATE...

Hello!

I've reached now the point to be able to write more than 255 chars into one column at least in the second row of data.

I use the following command:

INSERT INTO...

Hello Lowell!

I'm trying the following:

INSERT INTO OPENROWSET('msdasql','Driver={Microsoft Text Driver (*.txt; *.csv)};

DefaultDir=C:\zw\;Extended properties="text;HDR=Yes;IMEX=1";ColNameHeader=True;Format=Delimited;''',

'SELECT Text_To_Exec FROM BackupScheduler.txt WHERE 1=0')

SELECT REPLICATE ('a',255)

The above works fine and my textfile...

Thank You Lowell!

But my problem is still the same 🙁 :

Msg 8152, Level 16, State 14, Procedure sp_BACKUP_Scheduler, Line 80

String or binary data would be truncated.

Any other ideas?