Grass,

What is CTAs?

I want to make it clear that I not Expert in SSIS, but my logic is it:

1. truncate table [tblstaging]

2. load from csv to [tblstaging]

obs 1: I have no idea...

SSCrazy,

Temporary table i mean - table physical.. is not #table..

my temporary table have 255 nvarchar for all columns (ETL)...

and my target table is thin (column) i mean, first column nvarchar(16),...

Thanks man. I used xp_cmdshell call bat... and bat call .dtsx, in the case, all code in procedure not execute the same time, mas second step wait for first step.......

Grass, how can i pass two parameters in my application?

Grass, do you have an example? blog, site that describe that?

Thanks. Do you have any example to describe this?

the big problem is because i need pass to parameter (application) when execute this procedure, how can i pass two parameter in executing procedure or job ?

I can't use a SSDT in SQL Server 2012. Need to pass 2 parameters (table and dateimport) - procedure. in job, i don't know how can i do that'...

Thanks man!

Thanks you so much guy, but about this command:

DBCC SHRNIKDATABASE(<db_name>)

I use NOTRUNCATE, TRUNCATEONLY or some else?

i dont understand the perfect functionality of notruncante, truncateonly... i just have a free space...

1. a pre-built utility to migrate from mySQL to SQL server

is not good for me. my datavase have a 80GB and exists many erros..

2. the Built In Import Export Wizard...

Anyone?

the problem is because my disk have a 20gb free, and tlog is bigger then 20gb...

I've been saw these article, but i continue not understand why my transaction log to become big when i've simple recovery model...