Does the script task do anything with the file system , is the account that SQL server / SQL agent run under also a local windows account or domain account...

Hi,

I have come across this before and spent ages working on it ..may not be exact but see what we can do

The issue i had was that the original import...

GrassHopper ..never used this before and it is brilliant ...

Do these settings only get applied at package start or can you modify the properties of certain values within the SSIS_Configuration...

No Worries, as I Always create a staging table i have the benefit of doing stuff like this..

creating a staging table is always fairly simple..if you are using SSIS anyway

topman

cheers will give this a go

If your source is a sql statement (then you would use as part of the SQL statement..or if you can execute a SQL task that performs an update to the...

Hi

I have used this

i.e U_FormatDate getdate() , 'dd/mmm/yyy'

CREATE FUNCTION [dbo].[U_FormatDate] (@Date datetime, @Format varchar(256))

RETURNS varchar(256)

AS

BEGIN

IF @Date IS NULL RETURN('')

/*

dThe one-digit of the two-digit day.

ddThe two-digit...

Hopefully this is the Fix

http://support.microsoft.com/kb/942861