Great!

it worked

Thank you very much

Hello SSIS experts,

Any body reply to question please.

I am trying to create SSIS package using Import/Export wizard

exporting 300 tables data in to excel. getting error.

Is there any limitations?

I don't want to provide user data like name ssn address...

We have 250+ tables, and in every table we have user name and data etc....

So you want to update all tables which has user data? or any other way

Yes

Original Column data

1

1

1

1

Data in excel

-1

-1

-1

-1

Thank you,

I have used SQL IMPORT/EXPORT and successfully exported data into CSV file (Unix format).

But I have a issue with data/time format. Some of the fields only display...

mister.magoo (6/23/2010)

---

laddu4700 (6/23/2010)

---

Thank you,

But how to convert the CSV windows file into CSV (Unix format). Is there any feature in SQL Server, or any third party tools? Please let me...

Thanks Magoo,

Thank you,

But how to convert the CSV windows file into CSV (Unix format). Is there any feature in SQL Server, or any third party tools? Please let me know.

In our...

ldf are fine. I need to shrink mdf inorder to release some space

sp_spaceused details

database_namedatabase_sizeunallocated space

mydb 767.88 MB 0.08 MB

reserveddata ...

We have a space issue on drive, so need to shrink the data and log files for databases. I tried to shrink but the mdf and ldf file sizes remain...

Last friday I have installed Deklarit, but SQL Management studio was working fine, but I did't shutdown my laptop. Now after long weekend, today I am getting error to connect...

I agree with GilaMonster, it totally depends on company. Earlier I worked for a bank there...

I have uploaded the screenshots...Thanks