Hi Phil,

The files that are generated are of different...

Hi Phil,

Please find the script component code below....

Option Explicit Off

Option Strict Off

Imports System

Imports System.Data

Imports System.Math

Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper

Imports Microsoft.SqlServer.Dts.Runtime.Wrapper

Imports System.IO

Imports System.Text

<Microsoft.SqlServer.Dts.Pipeline.SSISScriptComponentEntryPointAttribute> _

<CLSCompliant(False)> _

Public Class ScriptMain

Inherits UserComponent

...

Thanks Phil for your input.

Hi,

Just declare the variable as 'String' type and then assign the value from ur Query to it.

Hi Welsh,

Here is my DDL statement:

CREATE TABLE [dbo].[SOURCE_ACTUALS](

[Entry Unit Code] [nvarchar](10) NOT NULL,

[OU_Code] [nvarchar](10) NULL,

[Currency Code] [nvarchar](4) NULL,

[Year/Month] [nvarchar](7) NOT NULL,

[Value Type] [nvarchar](3) NOT NULL,

[SFS line item code] [nvarchar](16) NOT...

Hi,

You can make this change through the properties of OLEDB source component.

Thanks

Sam

Hi Steve,

No i don't think tht option is feasible because the connection string for a OLEDB source is embedde within the component and u can't set it throught an expresion

Sam

Hi,

I'm able to generate the file name using the given expression.Make sure that the varaible @[User::ATMTW_File_Name] is having some default value in it (Check in the variables windows).

Thanks

sam

Hi,

Please find the snap shot for input/output properties of OLEDB source after you configure the SQL query

http://www.flickr.com/photos/48301078@N03/5578387805/

You need to add your column in both External and Output columns...

x

Please try to place ur Query for OLEDB source from properties windows itself. Don't try to edit the OLEDB source in this way you will by pass the error that...

Try the following step:

Select your DF task in Control Flow go to properties set DelayValidation to 'True'

Select Your OLEDB Source Component From Properties window select AccessMode to Sql Command

Set Your...

ISNULL ([COLUMN_B]) ? [COLUMN_A] : [COLUMN_B]

The above expression is correct, the only problem i see is while inserting data to Sample table you have used 'NULL', this won't work with...

Hi,

You have to use temp table as table variable will not work in your case.

First use a Execute SQL Task write you script here

SCRIPT

CREATE TABLE #GetInstances

(Value VARCHAR(30), InstanceNames VARCHAR(20),...