Great question about an undocumented feature!

In Excel, 0 equals FALSE for boolean values, and any other number equals TRUE.

However, I believe that Excel stores a boolean default as -1.

So, theoretically, nothing is wrong with your...

You have to options to reduce the column length from nvarchar(80) to nvarchar(6):

* Include a data conversion component. Select your column and set the length to 6.

* Or, go to...

According to BOL, the parameter size is used for the following:

Parameter Size

Provide the size of parameters that have variable length, such as strings and binary fields.

This setting ensures that...

To validate if the 4 files are present in the folder, you can use a Script Task. The code for this isn't really complex (if needed I can provide you...

If you go to the properties pane of the File System Task and you go to expressions (where you set the different paths), you can go to the expression editor....

What are the datatypes of the variables?

Glad to hear it all worked out fine 🙂

No problem, glad to help 🙂

Well, I'm glad it worked out in the end 🙂

To be definite on the subject:

you can only use the dataflow (flat file source and OLE DB Destination) dynamically if (and only if):

* the flat files have the same identical...

When you look at the value of the variable, is that when your package is running or after it has just ran?

To check, you can also include a messagebox in...

You need only to deploy your cube when you made changes to the cube itself.

If the data in your relational database has changed, then you need to process the cube...

T-SQL is much easier to handle conversions than the derived column component, but, depending on the specific situation, the derived column can process rows faster in a data flow (And...

Not sure SSIS is the right tool for this, but here goes:

* Read the file with a flat file source. Set it up as one column only.

* Add a derived...