Hi...

Thank you for your big response, my project is resolved.

🙂

Hi There,

Thank You for your suggestion.

I have three tables that identify the user's login information on an application.

There is TblProgram,TblProgramDetail,TblUserAccess.

CREATE TABLE [TblProgram](

[Byte] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[ProgramName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS...

Hi All,

Thank you for all your attention.

I already have solution, for make the report as I want;

there is solution:

1) Insert a table group on Model

2) Insert Group footer

3) In the...

Hi MC...

This is a good workaround to apply. And the best thing is that it works fine!!! 🙂

Thanks a lot, It was very help full!

Hi ... thank you for your share that's link.

previously I've read, even practicing.

And follows the results of the data:

Model Dateupload May June

AAA ...

Hi All..

I have some problem with you, but i try to created new CREDENTIAL and Proxy for SSIS Package Execution and use this proxy instead of sql server agent account,...

Hi Jack Corbett...thank you for your replay..

this is result from query :

Executed as user: Domain\Administrator. The package execution failed. The step failed.

Why its also get error like this, although...

Thanks Gianluca,

Thanks Gail Shaw

I get the simple solution from you.

Regads,

Thanks RBarryYoung San,

but I want to try to use the full features of sql server in processing this data.

for : CozyRoc San

Thank you. Really this is a Great...

Yes, I can modify the file, I also have to apply to the File system task with a Operation "COPY"

to another folder (i.e Folder_Temp)

I'm still confused, how to create a...

Yes, I can modify the file, I also have to apply to the File system task with a Operation "COPY"

to another folder (i.g Folder_Temp)

I'm still confused, how to create a...

I think if the case each month, the system add data in one folder with type process is replace file,your idea can be applied.

The problem is every month the system...

Thank you CozyRoc. Really this is a Great help.

how about this case:

the results of last month's data, appeared at the beginning of the month .

eg this month: this month...