SSIS can import fixed-width flat files as well - is that your file format?

Please describe how your flat file is organized - how can you tell where one field ends...

There may be no need for you to go to the extent of using a Script to process your cube. If you can generate the appropriate processing commands from...

Yes, using indirect configurations is a common solution. Your "common" environment variable can do several things - but in general, it should identify the location of a config file....

You can open 2005 packages in BIDS 2008 - it will automatically upgrade them. You won't then be able to execute them under 2005 anymore.

You can connect SSMS 2008...

You can't run packages developed in BIDS 2008 on an SSIS 2005 instance. You must develop your packages in BIDS 2005. No, you can not open your 2008...

You have a few options that can help you.

You can use SQL Profiler to monitor that database/table. The connection string the SSIS package uses should be part of the...

It's quite likely you just have the outputs hooked up to the wrong kind of persistence component. For example, you've used a Destination instead of an OLE DB Command...

If you're doing this in the Data Flow (which you should), then you can use the Multicast component to make "copies" of the data flow - one in, two (or...

To start, I wouldn't think of doing the above with plain T-SQL. SSIS moves data using the Data Flow Task. Use one of those.

Use an OLE DB Source...

You should review the options presented in this Range Lookup post by the SSIS Dev Team.

The error is stating "Cannot insert the value NULL into column 'Type_professionnels', table 'HealthCare_Ref.dbo.Individu'; column does not allow nulls."

Your table definition confirms this - the Type_professionels column does not permit...

You haven't understood correctly. The SSIS process has a 32-bit version as well as a 64-bit version. However, the packages themselves are bitness independent.

Therefore, as you've concluded, you...

Here's how I'd design it:

1. Create a simple "control" table in SQL. Identity PK, filename, file "type", Execution instance GUID, Start Time, End Time.

2. Create a "control" package. ...

I'm assuming that your [luaDate] column is a string type (DT_STR or DT_WSTR). The error you're getting implies that it's not.

An expression like this should work... Make sure...

Use a Conditional Split component to split off the "invalid" rows. Use a condition that checks that the LEN([Column]) == 10, and that SUBSTRING([Column], 3, 1) == "-".

You weren't...