Thanks a lot this worked, changing the line in the SP

INSERT INTO

dbo.tblClients(Client_Short_Name,Client_Long_Name,CountryCode,ClientID)

SELECT LEFT

(dbo.vwImportAllNewClientIDs.Client, 30),

dbo.vwImportAllNewClientIDs.Client,

dbo.vwImportAllNewClientIDs.CountryCode,

dbo.vwImportAllNewClientIDs.

ClientID

FROM dbo.vwImportAllNewClientIDs

If i run the SP line by line in QA it failes when it gets to the line:

INSERT INTO dbo.tblClients(Client_Short_Name,Client_Long_Name,CountryCode,ClientID)

SELECT

dbo.vwImportAllNewClientIDs.Client,

dbo.vwImportAllNewClientIDs.Client,

dbo.vwImportAllNewClientIDs.CountryCode,

dbo.vwImportAllNewClientIDs.ClientID

FROM dbo.vwImportAllNewClientIDs

Error:

Msg 8152, Level 16, State...

When I run you select statment I just get one row returned.

I think I found the issue, can you tell me how i would truncate the following line of code,...

Thanks again for your time!

CheckDate imports only one row one column

27/01/09

Any more suggestions?

Below is the SP in question, (sorry I was having problems with the formatting).

USE [DealbookV2]

GO

/****** Object: StoredProcedure [dbo].[procImportAllFiles] Script Date: 01/28/2009 07:57:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER...

Thanks but this does not work either.

Within FTP Task Editor:

- "IsRemotePathVariable" Set to "True"

- "RemoteVariable" set to

NameSpace: user

Value type: String

Value: "trial_bal_by_currency_11_SOD_1_LON_" + (DT_WSTR, 4) DATEPART( "yyyy", getdate()...

Could I put this in as a Vaule in the 'Add Variable' field

print 'football_results' + convert(char(4),datepart(year,getdate()))

+ case convert(char(2),datepart(month,getdate()))

WHEN 1 THEN '01'

WHEN 2 THEN '02'

WHEN 3 THEN '03'

WHEN...

Oh and the date format will always be...

20090123

So the full file name would be

Football_Results_20090123.pdf

Thank you, this is where im having the problem, constructing a variable based on the date.

The file name it 'Football_Results_TODAYSDATE.pdf'

So in the 'Add Variable' box under Value can you help...

Please any ideas would be helpful!

Dude, where do we start! there many ways to do this.

Simplest would be,

Assuming the following:

- You will have the same tables during every import

- You have already worked...

Thank you very very much that worked well!

thanks for your time

Does the FlatFile Manager need to be changed?

Thanks for the detailed information.

I have made the changes you have suggeste dand Mapped the OLE DM Column to the New Alis.

I am still getting the same error.

Is there anything...

Thanks,

I have:

1. added the DC betweent he flat file and the OLE DB.

2. Selected the column needed

I cannot seen how to truncate the data?