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...

As I read the description of dtexec at BOL, the statement should take the following form:

dtexec /f mypackage.dtsx /set \package.variables[myvariable].Value;myvalue

This without the Properties.

Can you try that?

In my native language, schema and diagram are synonyms.

You should've asked your question more clearly.

But on to the question:

click on Database in the menu and then choose Generate Relation Schema.

A...