you wont be able to determine the data if its all written in a single flat file.

these should be single file per object(table). you have make a custom SSIS package...

SSIS Package extension is "dtsx" not "dstx".

There is a workaround in which you can use OPENROWSET to call a stored procedure from a function; however, this is in general a bad idea and should be avoided.

+1 , its way better...

you want all tables data in a single FLAT File is that what you are looking for ?

can you use this

Update dd

set dd.IsDelete = 'D'

From dbo.tblcustomerTarget dd

Left join dbo.tblcustomerSource d on d.custid = dd.custid

Where d.custid is null

In SSIS Max is considered as "DT_TEXT", and the destination Column SHOULD BE "DT_TEXT" to aviod truncation. otherwise you have to implicitly convert the "DT_TEXT" to "DT_STR" or "DT_WSTR".

FOR FLAT...

+1, nice knowledge base question 😉

This function is using Tally Table approach to generate calendar date between the @startDate And @EndDate

if you want to understand properly then using this post from Stefan Krzywicki "Tally Table...

when you say "Load data in production server"

its means you process the file or you bring the data from the Source database.

If its source database check if the what kind...

Paul is right

if you looking for code it will look something like this

=IIF(Fields!TotalDue.Value = 0,"0.00;(0.00)","0.000000;(0.000000)")

nice question to recall the basics 🙂

thanks for sharing

Paul White (11/26/2013)

---

I've just noticed that "IsAllDigits" includes fractions:

-- True

SELECT IsAllDigits

FROM dbo.IsAllDigits('1¼');

-- True

SELECT IsAllDigits

FROM dbo.IsAllDigits('¾5¼');

Collation-related of course. There is more between 0 and 9 than just the integers....

one of my most favorite is the join condition with

isnull(a.col1) = isnull(b.col1)

if this not helpful then people usually go for custom solution like

udf_isnull(a.col1) = udf_isnull(b.col1)

😀

i got it right ...

Nice question 🙂