At my current project I deploy packages I'm developing in a subversion folder to the test environment by simply using the deploying capabilities of BIDS Helper in BIDS.

From test to...

A possible approach is to use a scripting component to undouble the column. In other words, make sure that each data item has its own row (so no rows with...

I sure hope that the original poster found the solution to his problem two years ago...

Try the following statement when you select your data:

select convert(datetime,replace(myColumn,'.',':')) from myTable

It works for the example that you provided.

Do this in the OLE DB Source, not in a derived column...

Well, thanks for...

I sure hope that there aren't any spambots searching this forum looking for e-mails 😉

Learned something new today. Thanks for letting us know.

Very common best practices:

- never use *, always select and the columns you need. Not only in OLE_SRC, everywhere. (e.g. lookup component)

Limit the results of the queries with appropriate where...

What I would answer on those questions:

4. Updates: only if corrections are allowed to be made. Otherwise it is just a new fact.

Deletes: if the fact tables contains snapshot, I...

Not sure this belongs in a BI forum,

but I believe that since you've enclosed the variables between quotes, they become part of the string and they are not interpreted as...

Do you type in 0.74 yourself or is the data already present in the Excel sheet.

It is possible that the actual value is 0.7933 and that Excel formats it in...

At SQL-IS there are a few articles on how to create packages programmatically. However, I'm not sure they use XML.

Also, there is no spoon 😉

(where is my morning coffee?)

First hit on Google when searching for You can not debug or run this project, because the required version of the Microsoft Office application is not installed SSIS script task...

You mentioned a temporary table.

When SSIS starts evaluating your package, the temporary table doesn't exist yet.

Hence, he will find a reference to an object that he cannot find.

Solution: you must...