Phil Parkin (5/16/2011)

---

When it come to mapping of SSIS data type and SQL Server datatype then nchar, nvarchar, sql_variant, xml will be mapped directly to DT_WSTR (SSIS data type). Any...

Addition to the difference given by phil:

When it...

Convert to "Unicode String [DT_WSTR]" instead of [DT_STR]

radb4u (5/13/2011)

---

Thank you for the response. Lookup is required for the package but I want to know the flow of the data. In short I have the following tables which...

Why not you go for passing 2 parameters that will take value from GETDATE()-7 days to GETDATE()-1 day . This will be better approach than creating table as changing schema...

Need to detail as your requirement is not pretty clear ..

If I got your problem correctly then this is the One way to do that:

Write the last modified date in your err-output.txt file. Then at the end of your package...

Use expressions to generate folder name at run time in the format Name_MMDDYYYY instead of giving hard coded value.

@Koen

I also want to know the same. It seems, by mistake you gave this post link only.

Bhavika, What is this FST by the way

Hi,

One way to do is like this way-

1) Drag n Drop a FileSystem task to the SSIS workflow.

2) Edit it. Specify source and destination connection (Any hard coded excel file...

bhavika.chauhan (4/18/2011)

---

Hi,

While exporting the data , i need to send it to Excel file. While doing so i want to Create a specific folder and then save the excel file...

You can't change the data type to DT_WSTR directly in the excel source. Better to use Data Type Conversion transformation to transform input into DT_WSTR, which are not supported by...

Elliott Whitlow (4/15/2011)

---

I agree, you don't need to know DTS intimately. The wizard does ok, but will usually no do a very good job with even a slightly complex package...

See the...