Hi Daniel,

I will need a little bit more details in order to help you.

- Which SQL Server version are you using?

- As far as I've understood, you have implemented...

I think I faced this situation before and what I did (maybe is not the smart way) is to parse the strings using an expression in a Derived Column component....

Hi all,

thanks Phil and Mack for your quick answer.

In my scenario both options (stored procedure and script taks) work fine.

I need to update an operational CRM (Dynamics - SQL...

Hi,

just an idea. Maybe is an indirect way, but what about to use a Script Component or a Script Task and use C# to proccess the csv file. There is...

Hi,

I recently had to use a script task to get the modification date of a group of files within a folder. With the Foreach loop task is possible to iterate...

Thanks Daniel for your quick reply.

In my case the problem was the connection string of the Cozyroc Dynamics CRM Destination. It has a long connection string. The solution was to...

Hi sqlgirlatty,

have you solved this problem?

Thanks in advance.

Hi Sam:

The complete architecture of a DW loading process is too complex to resume it in a forum post. What I can give you are only general tips:

- I think...

Hi,

In my current job the Cozyroc componets are used and I can recommend them. It´s a supported way to write data into the CRM entities. However, to make a backup...

Hi Sam,

I need more details to make a suggestion:

- Do all the dimensions conform? That is, the dimensions are common to all of the fact tables.

- You said that there...

Hi,

Why is the difference between a regular folder and a dropbox folder?

If there's no difference I think you only need to filter which file extension do you want to read....

Thanks so much again Phil,

I followed your suggestion and that makes the difference. I reduced the execution time from more than one hour using the foreach file enumerator, to just...

Hi Phil,

Thanks for your quick response.

I need only to log the filename, path and modify date in a table.

Background: I receive digital card request in pdf format. The name of...

Hi Lokesh Vij,

thanks so much for your quick and HELPFUL answer. That´s right, that is exactly what I needed.

In fact, I´m loading the final table using an SSIS...

Hi everyone, and thank you Adam for this great article.

I'm wondering if it is possible to have a mix approach in one table, something like a Type 1 and 2...