Is it always the same length?

Is it always the last part before the zip?

you could strip the .zip from the filename and then...

you may have a process that needs to be called from a number of different workflows. For example, I have a package that generates an export file for consumption...

My first port of call would be Reporting Services:

You can build a DW which allows users to create simple drag and drop reports but still provides enough flexibilty for advanced...

in the Excel data source the incoming data will be called Field1,Field2,Field3

What you do with them is completely up to you and the dataflow.

You will have two different types of...

OK. I get the data, and your diagram is like I thought it would look.

Why can you not put in a formula in Excel to bring the TPA/TPB down...

JayWinter (8/8/2013)

---

I have an SQL table called RETAIL_SALES that contains the columns: DATE,STYLE,QTY. Using SSIS, I populate RETAIL_SALES using an Excel data source that contains only STYLE & QTY. I...

@Raghavendar

I am confused:-P

The problem was not well explained in your first post. I am thinking that what you have is two different record types: A header record and some...

Excellent!

Yet another good reason not to use Excel as a datasource with SSIS.

I can't believe how badly these two MS flagship products play together. Each is excellent...

or add FOR XML to the end of the query, that way the results will be in XML rather than their columns with the associated data types. the XML...

Please post your solution for others to learn from.

If it was me, I would

Create an object variable

Create a dataflow task

in the DFT:

create an ole source which is the SQL...

If you are using openrowset in SQL then UNION ALL is your solution. You posted this on the SSIS forum so I am presuming not.

Create three ole data connections,...

Lets expand on this a bit then...

My original suggestion of

Lang|Text|Translation was to clarity on the existing data. In reality the lookup table would be

Context|Lang|Text|Result

Day|FR|Lundi|1

Day|EN|Monday|1

Day|DR|Montag|1

...

Month|FR|Janvier|1

...

Month|EN|July7

etc...

The lookup would then specify...

I know this is an old thread but I thought this was worth adding:

I was getting the error message

Test connection failed because of an error in initializing provider. External table...

@ asita,

Do you understnad what Marks code does. If not you need to have it explained; don't just use it if you can't replicate it.

+1 for the trigger solution.

If you are still in your probation period at this new company, remember that the assessment goes both ways ! :w00t: